Dataset info
| Number of variables | 183 |
|---|---|
| Number of observations | 265 |
| Missing cells | 21158 (43.6%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 365.6 KiB |
| Average record size in memory | 1.4 KiB |
Variables types
| Numeric | 63 |
|---|---|
| Categorical | 23 |
| Boolean | 25 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 1 |
| Rejected | 71 |
| Unsupported | 0 |
Warnings
coligada_mais_antiga_ativa has 189 (71.3%) missing values | Missing |
coligada_mais_antiga_baixada has 264 (99.6%) missing values | Missing |
coligada_mais_nova_ativa has 189 (71.3%) missing values | Missing |
coligada_mais_nova_baixada has 264 (99.6%) missing values | Missing |
de_indicador_telefone has 71 (26.8%) missing values | Missing |
dt_situacao only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
dt_situacao has a high cardinality: 129 distinct values | Warning |
empsetorcensitariofaixarendapopulacao has 48 (18.1%) missing values | Missing |
faturamento_est_coligados has 191 (72.1%) missing values | Missing |
faturamento_est_coligados_gp is highly correlated with faturamento_est_coligados (ρ = 0.9725637856) | Rejected |
fl_epp has constant value "False" | Rejected |
fl_matriz has constant value "True" | Rejected |
fl_me has constant value "False" | Rejected |
fl_mei has constant value "False" | Rejected |
fl_passivel_iss has constant value "True" | Rejected |
fl_st_especial has constant value "False" | Rejected |
grau_instrucao_macro_analfabeto has 201 (75.8%) missing values | Missing |
grau_instrucao_macro_desconhecido has constant value "nan" | Rejected |
grau_instrucao_macro_escolaridade_fundamental has 12 (4.5%) missing values | Missing |
grau_instrucao_macro_escolaridade_superior has 3 (1.1%) missing values | Missing |
idade_acima_de_58 has 8 (3.0%) missing values | Missing |
idade_ate_18 has 208 (78.5%) missing values | Missing |
idade_de_19_a_23 has 76 (28.7%) missing values | Missing |
idade_de_24_a_28 is highly correlated with idade_de_19_a_23 (ρ = 0.9391201682) | Rejected |
idade_de_39_a_43 is highly correlated with idade_de_34_a_38 (ρ = 0.9147291585) | Rejected |
idade_de_44_a_48 is highly correlated with idade_de_39_a_43 (ρ = 0.9376949593) | Rejected |
idade_de_54_a_58 is highly correlated with idade_acima_de_58 (ρ = 0.9500453674) | Rejected |
idade_maxima_coligadas is highly correlated with coligada_mais_antiga_ativa (ρ = 0.990757127) | Rejected |
idade_maxima_socios has 172 (64.9%) missing values | Missing |
idade_media_coligadas has 189 (71.3%) missing values | Missing |
idade_media_coligadas_ativas is highly correlated with idade_media_coligadas (ρ = 0.9928275535) | Rejected |
idade_media_coligadas_baixadas has 264 (99.6%) missing values | Missing |
idade_media_socios has 172 (64.9%) missing values | Missing |
idade_minima_coligadas is highly correlated with coligada_mais_nova_ativa (ρ = 1) | Rejected |
idade_minima_socios is highly correlated with idade_media_socios (ρ = 0.9030093563) | Rejected |
max_faturamento_est_coligados is highly correlated with faturamento_est_coligados (ρ = 0.9484709664) | Rejected |
max_faturamento_est_coligados_gp is highly correlated with max_faturamento_est_coligados (ρ = 0.9515331439) | Rejected |
max_filiais_coligados has 229 (86.4%) missing values | Missing |
max_funcionarios_coligados_gp is highly correlated with max_filiais_coligados (ρ = 0.9312487825) | Rejected |
max_vl_folha_coligados has 207 (78.1%) missing values | Missing |
max_vl_folha_coligados_gp has 206 (77.7%) missing values | Missing |
media_faturamento_est_coligados is highly correlated with max_faturamento_est_coligados (ρ = 0.9075319591) | Rejected |
media_faturamento_est_coligados_gp is highly correlated with media_faturamento_est_coligados (ρ = 0.9465645673) | Rejected |
media_filiais_coligados has 229 (86.4%) missing values | Missing |
media_funcionarios_coligados_gp has 4 (1.5%) zeros | Zeros |
media_funcionarios_coligados_gp has 202 (76.2%) missing values | Missing |
media_vl_folha_coligados has 207 (78.1%) missing values | Missing |
media_vl_folha_coligados_gp has 206 (77.7%) missing values | Missing |
min_faturamento_est_coligados has 191 (72.1%) missing values | Missing |
min_faturamento_est_coligados_gp is highly correlated with min_faturamento_est_coligados (ρ = 0.9844779291) | Rejected |
min_filiais_coligados has 229 (86.4%) missing values | Missing |
min_funcionarios_coligados_gp is highly correlated with min_filiais_coligados (ρ = 0.916066893) | Rejected |
min_meses_servicos is highly correlated with meses_ultima_contratacaco (ρ = 0.9567491686) | Rejected |
min_meses_servicos_all has 19 (7.2%) zeros | Zeros |
min_vl_folha_coligados is highly correlated with min_funcionarios_coligados_gp (ρ = 0.9989755332) | Rejected |
min_vl_folha_coligados_gp is highly correlated with min_vl_folha_coligados (ρ = 0.9991732114) | Rejected |
nm_meso_regiao has 24 (9.1%) missing values | Missing |
nm_micro_regiao has a high cardinality: 57 distinct values | Warning |
nm_micro_regiao has 24 (9.1%) missing values | Missing |
qt_admitidos_12meses has 162 (61.1%) zeros | Zeros |
qt_alteracao_socio_180d has constant value "nan" | Rejected |
qt_alteracao_socio_365d has constant value "nan" | Rejected |
qt_alteracao_socio_90d has constant value "nan" | Rejected |
qt_alteracao_socio_total has constant value "nan" | Rejected |
qt_art has 135 (50.9%) missing values | Missing |
qt_coligadas has 189 (71.3%) missing values | Missing |
qt_coligados is highly correlated with qt_coligadas (ρ = 1) | Rejected |
qt_coligados_agropecuaria has 189 (71.3%) missing values | Missing |
qt_coligados_atividade_alto has 189 (71.3%) missing values | Missing |
qt_coligados_atividade_baixo has 189 (71.3%) missing values | Missing |
qt_coligados_atividade_inativo has 189 (71.3%) missing values | Missing |
qt_coligados_atividade_medio has 189 (71.3%) missing values | Missing |
qt_coligados_atividade_mt_baixo has 189 (71.3%) missing values | Missing |
qt_coligados_ativo is highly correlated with qt_coligados (ρ = 0.9997516702) | Rejected |
qt_coligados_baixada is highly correlated with max_funcionarios_coligados_gp (ρ = 0.9718460044) | Rejected |
qt_coligados_ccivil has 189 (71.3%) missing values | Missing |
qt_coligados_centro has 68 (25.7%) zeros | Zeros |
qt_coligados_centro has 189 (71.3%) missing values | Missing |
qt_coligados_comercio has 46 (17.4%) zeros | Zeros |
qt_coligados_comercio has 189 (71.3%) missing values | Missing |
qt_coligados_epp has 189 (71.3%) missing values | Missing |
qt_coligados_exterior has 189 (71.3%) missing values | Missing |
qt_coligados_inapta is highly correlated with max_funcionarios_coligados_gp (ρ = 0.9718460044) | Rejected |
qt_coligados_industria has 63 (23.8%) zeros | Zeros |
qt_coligados_industria has 189 (71.3%) missing values | Missing |
qt_coligados_ltda has 69 (26.0%) zeros | Zeros |
qt_coligados_ltda has 189 (71.3%) missing values | Missing |
qt_coligados_matriz is highly correlated with qt_coligados_ativo (ρ = 0.9996971343) | Rejected |
qt_coligados_me has 189 (71.3%) missing values | Missing |
qt_coligados_mei has 189 (71.3%) missing values | Missing |
qt_coligados_nordeste has 31 (11.7%) zeros | Zeros |
qt_coligados_nordeste has 189 (71.3%) missing values | Missing |
qt_coligados_norte has 39 (14.7%) zeros | Zeros |
qt_coligados_norte has 189 (71.3%) missing values | Missing |
qt_coligados_nula has 189 (71.3%) missing values | Missing |
qt_coligados_sa has 64 (24.2%) zeros | Zeros |
qt_coligados_sa has 189 (71.3%) missing values | Missing |
qt_coligados_serviço is highly correlated with qt_coligados_matriz (ρ = 0.9288399907) | Rejected |
qt_coligados_sudeste has 65 (24.5%) zeros | Zeros |
qt_coligados_sudeste has 189 (71.3%) missing values | Missing |
qt_coligados_sul is highly correlated with qt_coligados_baixada (ρ = 0.9612903226) | Rejected |
qt_coligados_suspensa has 189 (71.3%) missing values | Missing |
qt_desligados is highly correlated with qt_admitidos (ρ = 0.905610227) | Rejected |
qt_desligados_12meses has 159 (60.0%) zeros | Zeros |
qt_ex_funcionarios is highly correlated with qt_desligados (ρ = 0.9999991015) | Rejected |
qt_filiais has 155 (58.5%) zeros | Zeros |
qt_funcionarios_12meses is highly correlated with qt_funcionarios (ρ = 0.9948729203) | Rejected |
qt_funcionarios_24meses is highly correlated with qt_funcionarios_12meses (ρ = 0.968894117) | Rejected |
qt_funcionarios_coligados has 5 (1.9%) zeros | Zeros |
qt_funcionarios_coligados has 202 (76.2%) missing values | Missing |
qt_funcionarios_coligados_gp is highly correlated with qt_coligados_inapta (ρ = 0.9231363224) | Rejected |
qt_funcionarios_grupo is highly correlated with qt_funcionarios_24meses (ρ = 0.9502971077) | Rejected |
qt_ramos_coligados is highly correlated with qt_coligados_matriz (ρ = 0.9346159264) | Rejected |
qt_regioes_coligados has 189 (71.3%) missing values | Missing |
qt_socios is highly correlated with qt_coligados_mei (ρ = 0.9899466719) | Rejected |
qt_socios_coligados has 189 (71.3%) missing values | Missing |
qt_socios_feminino is highly correlated with qt_socios (ρ = 0.9936468189) | Rejected |
qt_socios_masculino is highly correlated with qt_socios_feminino (ρ = 0.9916264524) | Rejected |
qt_socios_pep is highly correlated with qt_socios_masculino (ρ = 0.9954550751) | Rejected |
qt_socios_pf is highly correlated with qt_socios_pep (ρ = 0.9960939342) | Rejected |
qt_socios_pj has 83 (31.3%) zeros | Zeros |
qt_socios_pj has 167 (63.0%) missing values | Missing |
qt_socios_pj_ativos is highly correlated with qt_socios_pj (ρ = 1) | Rejected |
qt_socios_pj_baixados has 250 (94.3%) missing values | Missing |
qt_socios_pj_inaptos has 250 (94.3%) missing values | Missing |
qt_socios_pj_nulos has 250 (94.3%) missing values | Missing |
qt_socios_pj_suspensos has 250 (94.3%) missing values | Missing |
qt_socios_st_regular is highly correlated with qt_socios_pf (ρ = 0.9983592345) | Rejected |
qt_socios_st_suspensa has constant value "nan" | Rejected |
qt_ufs_coligados is highly correlated with qt_regioes_coligados (ρ = 0.9026409791) | Rejected |
setor has constant value "SERVIÇO" | Rejected |
sg_uf_matriz is a recoding of sg_uf | Rejected |
sum_faturamento_estimado_coligadas is highly correlated with media_faturamento_est_coligados_gp (ρ = 0.9016602831) | Rejected |
total is highly correlated with qt_funcionarios_grupo (ρ = 0.9743124436) | Rejected |
total_filiais_coligados is highly correlated with qt_funcionarios_coligados_gp (ρ = 0.9354643228) | Rejected |
tx_crescimento_12meses has 161 (60.8%) zeros | Zeros |
tx_crescimento_24meses is highly correlated with tx_crescimento_12meses (ρ = 0.9959598268) | Rejected |
tx_rotatividade has 160 (60.4%) zeros | Zeros |
Unnamed_0_y is highly correlated with Unnamed_0_x (ρ = 0.9988970638) | Rejected |
vl_faturamento_estimado_grupo_aux is highly correlated with vl_faturamento_estimado_aux (ρ = 0.9811022766) | Rejected |
vl_folha_coligados is highly correlated with qt_funcionarios_coligados (ρ = 0.961120251) | Rejected |
vl_folha_coligados_gp is highly correlated with vl_folha_coligados (ρ = 0.9428868609) | Rejected |
vl_frota is highly correlated with qt_socios_pep (ρ = 0.9138805515) | Rejected |
vl_idade_maxima_socios_pj has 250 (94.3%) missing values | Missing |
vl_idade_media_socios_pj has 250 (94.3%) missing values | Missing |
vl_idade_minima_socios_pj has 250 (94.3%) missing values | Missing |
vl_potenc_cons_oleo_gas has 243 (91.7%) missing values | Missing |
vl_total_tancagem has 255 (96.2%) missing values | Missing |
vl_total_tancagem_grupo is highly correlated with vl_idade_minima_socios_pj (ρ = 0.9444166274) | Rejected |
vl_total_veiculos_antt has constant value "nan" | Rejected |
vl_total_veiculos_antt_grupo has constant value "nan" | Rejected |
vl_total_veiculos_leves is highly correlated with qt_socios_pep (ρ = 0.9328182339) | Rejected |
vl_total_veiculos_leves_grupo is highly correlated with vl_total_veiculos_leves (ρ = 0.9972729314) | Rejected |
vl_total_veiculos_pesados is highly correlated with vl_potenc_cons_oleo_gas (ρ = 0.9929030146) | Rejected |
vl_total_veiculos_pesados_grupo is highly correlated with vl_total_veiculos_pesados (ρ = 0.9978083954) | Rejected |
coligada_mais_antiga_ativa
Numeric
| Distinct count | 77 |
|---|---|
| Unique (%) | 29.1% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 289.7526316 |
|---|---|
| Minimum | 2.3 |
| Maximum | 642.6666667 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2.3 |
|---|---|
| 5-th percentile | 24.475 |
| Q1 | 116.3083333 |
| Median | 272.7833333 |
| Q3 | 414.3416667 |
| 95-th percentile | 634.2166667 |
| Maximum | 642.6666667 |
| Range | 640.3666667 |
| Interquartile range | 298.0333333 |
Descriptive statistics
| Standard deviation | 193.4929426 |
|---|---|
| Coef of variation | 0.667786662 |
| Kurtosis | -1.021551163 |
| Mean | 289.7526316 |
| MAD | 162.5111727 |
| Skewness | 0.318938033 |
| Sum | 22021.2 |
| Variance | 37439.51885 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 408.4666667 | 1 | 0.4% | |
| 25.56666667 | 1 | 0.4% | |
| 42.36666667 | 1 | 0.4% | |
| 273.1666667 | 1 | 0.4% | |
| 194.2333333 | 1 | 0.4% | |
| 74.76666667 | 1 | 0.4% | |
| 5.8 | 1 | 0.4% | |
| 404.8 | 1 | 0.4% | |
| 178.3666667 | 1 | 0.4% | |
| 108.4666667 | 1 | 0.4% | |
| Other values (66) | 66 | 24.9% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2.3 | 1 | 0.4% | |
| 5.8 | 1 | 0.4% | |
| 19.1 | 1 | 0.4% | |
| 21.2 | 1 | 0.4% | |
| 25.56666667 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 642.6666667 | 1 | 0.4% | |
| 635.4666667 | 1 | 0.4% | |
| 635.2333333 | 1 | 0.4% | |
| 634.2666667 | 1 | 0.4% | |
| 634.2 | 1 | 0.4% |
coligada_mais_antiga_baixada
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 99.6% |
| Missing (n) | 264 |
| 190.9 | 1 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 190.9 | 1 | 0.4% | |
| (Missing) | 264 | 99.6% |
| Max length | 5 |
|---|---|
| Mean length | 3.00754717 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
coligada_mais_nova_ativa
Numeric
| Distinct count | 74 |
|---|---|
| Unique (%) | 27.9% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 92.76929825 |
|---|---|
| Minimum | 2.033333333 |
| Maximum | 498.9666667 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2.033333333 |
|---|---|
| 5-th percentile | 3.65 |
| Q1 | 16.65833333 |
| Median | 39.41666667 |
| Q3 | 122.0416667 |
| 95-th percentile | 334.4 |
| Maximum | 498.9666667 |
| Range | 496.9333333 |
| Interquartile range | 105.3833333 |
Descriptive statistics
| Standard deviation | 110.7867162 |
|---|---|
| Coef of variation | 1.194217466 |
| Kurtosis | 2.452633587 |
| Mean | 92.76929825 |
| MAD | 84.73578024 |
| Skewness | 1.677094953 |
| Sum | 7050.466667 |
| Variance | 12273.6965 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 21.2 | 2 | 0.8% | |
| 19.1 | 2 | 0.8% | |
| 96.96666667 | 2 | 0.8% | |
| 109.8333333 | 1 | 0.4% | |
| 8.033333333 | 1 | 0.4% | |
| 83.83333333 | 1 | 0.4% | |
| 95.96666667 | 1 | 0.4% | |
| 377.9 | 1 | 0.4% | |
| 116.1333333 | 1 | 0.4% | |
| 222 | 1 | 0.4% | |
| Other values (63) | 63 | 23.8% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2.033333333 | 1 | 0.4% | |
| 2.3 | 1 | 0.4% | |
| 2.4 | 1 | 0.4% | |
| 3.2 | 1 | 0.4% | |
| 3.8 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 498.9666667 | 1 | 0.4% | |
| 408.4666667 | 1 | 0.4% | |
| 377.9 | 1 | 0.4% | |
| 355.8 | 1 | 0.4% | |
| 327.2666667 | 1 | 0.4% |
coligada_mais_nova_baixada
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 99.6% |
| Missing (n) | 264 |
| 190.9 | 1 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 190.9 | 1 | 0.4% | |
| (Missing) | 264 | 99.6% |
| Max length | 5 |
|---|---|
| Mean length | 3.00754717 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
de_faixa_faturamento_estimado
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| DE R$ 30.000.000,01 A R$ 100.000.000,00 | |
|---|---|
| DE R$ 10.000.000,01 A R$ 30.000.000,00 | |
| DE R$ 100.000.000,01 A R$ 300.000.000,00 | |
| Other values (3) | 17 |
| Value | Count | Frequency (%) | |
| DE R$ 30.000.000,01 A R$ 100.000.000,00 | 138 | 52.1% | |
| DE R$ 10.000.000,01 A R$ 30.000.000,00 | 61 | 23.0% | |
| DE R$ 100.000.000,01 A R$ 300.000.000,00 | 49 | 18.5% | |
| DE R$ 300.000.000,01 A R$ 500.000.000,00 | 9 | 3.4% | |
| DE R$ 500.000.000,01 A 1 BILHAO DE REAIS | 6 | 2.3% | |
| ACIMA DE 1 BILHAO DE REAIS | 2 | 0.8% |
| Max length | 40 |
|---|---|
| Mean length | 38.91320755 |
| Min length | 26 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
de_faixa_faturamento_estimado_grupo
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| DE R$ 30.000.000,01 A R$ 100.000.000,00 | |
|---|---|
| DE R$ 10.000.000,01 A R$ 30.000.000,00 | |
| DE R$ 100.000.000,01 A R$ 300.000.000,00 | |
| Other values (3) | 17 |
| Value | Count | Frequency (%) | |
| DE R$ 30.000.000,01 A R$ 100.000.000,00 | 135 | 50.9% | |
| DE R$ 10.000.000,01 A R$ 30.000.000,00 | 59 | 22.3% | |
| DE R$ 100.000.000,01 A R$ 300.000.000,00 | 54 | 20.4% | |
| DE R$ 300.000.000,01 A R$ 500.000.000,00 | 7 | 2.6% | |
| DE R$ 500.000.000,01 A 1 BILHAO DE REAIS | 7 | 2.6% | |
| ACIMA DE 1 BILHAO DE REAIS | 3 | 1.1% |
| Max length | 40 |
|---|---|
| Mean length | 38.88679245 |
| Min length | 26 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
de_indicador_telefone
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 26.8% |
| Missing (n) | 71 |
| BOA | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| BOA | 194 | 73.2% | |
| (Missing) | 71 | 26.8% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
de_natureza_juridica
Categorical
| Distinct count | 25 |
|---|---|
| Unique (%) | 9.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| MUNICIPIO | |
|---|---|
| SOCIEDADE EMPRESARIA LIMITADA | |
| ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERAL | 20 |
| Other values (22) |
| Value | Count | Frequency (%) | |
| MUNICIPIO | 108 | 40.8% | |
| SOCIEDADE EMPRESARIA LIMITADA | 62 | 23.4% | |
| ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERAL | 20 | 7.5% | |
| EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA | 13 | 4.9% | |
| ORGAO PUBLICO DO PODER EXECUTIVO MUNICIPAL | 9 | 3.4% | |
| ASSOCIACAO PRIVADA | 8 | 3.0% | |
| AUTARQUIA ESTADUAL OU DO DISTRITO FEDERAL | 6 | 2.3% | |
| SERVICO SOCIAL AUTONOMO | 5 | 1.9% | |
| COOPERATIVA | 4 | 1.5% | |
| AUTARQUIA FEDERAL | 4 | 1.5% | |
| Other values (15) | 26 | 9.8% |
| Max length | 70 |
|---|---|
| Mean length | 25.58490566 |
| Min length | 9 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
de_nivel_atividade
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| ALTA | |
|---|---|
| MEDIA | 26 |
| BAIXA | 3 |
| Value | Count | Frequency (%) | |
| ALTA | 236 | 89.1% | |
| MEDIA | 26 | 9.8% | |
| BAIXA | 3 | 1.1% |
| Max length | 5 |
|---|---|
| Mean length | 4.109433962 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
de_ramo
Categorical
| Distinct count | 16 |
|---|---|
| Unique (%) | 6.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | |
|---|---|
| SERVICOS ADMINISTRATIVOS | |
| SERVICOS DE EDUCACAO | 22 |
| Other values (13) |
| Value | Count | Frequency (%) | |
| ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | 150 | 56.6% | |
| SERVICOS ADMINISTRATIVOS | 35 | 13.2% | |
| SERVICOS DE EDUCACAO | 22 | 8.3% | |
| TRANSPORTE, ARMAZENAGEM E CORREIO | 14 | 5.3% | |
| SERVICOS DE SAUDE | 13 | 4.9% | |
| SERVICOS DE SANEAMENTO BASICO | 5 | 1.9% | |
| SERVICOS DE ALOJAMENTO/ALIMENTACAO | 5 | 1.9% | |
| SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS | 5 | 1.9% | |
| SERVICOS DIVERSOS | 4 | 1.5% | |
| TELECOM | 3 | 1.1% | |
| Other values (6) | 9 | 3.4% |
| Max length | 49 |
|---|---|
| Mean length | 38.54716981 |
| Min length | 7 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
de_saude_rescencia
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| ACIMA DE 1 ANO | |
|---|---|
| SEM INFORMACAO | 1 |
| ATE 1 ANO | 1 |
| Value | Count | Frequency (%) | |
| ACIMA DE 1 ANO | 263 | 99.2% | |
| SEM INFORMACAO | 1 | 0.4% | |
| ATE 1 ANO | 1 | 0.4% |
| Max length | 14 |
|---|---|
| Mean length | 13.98113208 |
| Min length | 9 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
de_saude_tributaria
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | 1.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| VERDE | |
|---|---|
| AZUL | |
| LARANJA | 20 |
| Other values (2) | 3 |
| Value | Count | Frequency (%) | |
| VERDE | 159 | 60.0% | |
| AZUL | 83 | 31.3% | |
| LARANJA | 20 | 7.5% | |
| VERMELHO | 2 | 0.8% | |
| CINZA | 1 | 0.4% |
| Max length | 8 |
|---|---|
| Mean length | 4.860377358 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
dt_situacao
Categorical
| Distinct count | 129 |
|---|---|
| Unique (%) | 48.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2005-11-03 | |
|---|---|
| 1998-07-28 | 13 |
| 2005-09-24 | 10 |
| Other values (126) |
| Value | Count | Frequency (%) | |
| 2005-11-03 | 85 | 32.1% | |
| 1998-07-28 | 13 | 4.9% | |
| 2005-09-24 | 10 | 3.8% | |
| 2005-10-14 | 4 | 1.5% | |
| 1999-02-27 | 4 | 1.5% | |
| 2005-08-27 | 4 | 1.5% | |
| 2005-10-28 | 4 | 1.5% | |
| 2005-10-07 | 3 | 1.1% | |
| 2005-08-06 | 3 | 1.1% | |
| 2005-10-22 | 3 | 1.1% | |
| Other values (119) | 132 | 49.8% |
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
empsetorcensitariofaixarendapopulacao
Numeric
| Distinct count | 208 |
|---|---|
| Unique (%) | 78.5% |
| Missing (%) | 18.1% |
| Missing (n) | 48 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1587.10682 |
|---|---|
| Minimum | 297.41 |
| Maximum | 6347.86 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 297.41 |
|---|---|
| 5-th percentile | 405.494 |
| Q1 | 708.95 |
| Median | 1072.28 |
| Q3 | 2179.92 |
| 95-th percentile | 4133.876 |
| Maximum | 6347.86 |
| Range | 6050.45 |
| Interquartile range | 1470.97 |
Descriptive statistics
| Standard deviation | 1235.757393 |
|---|---|
| Coef of variation | 0.7786226969 |
| Kurtosis | 2.385943631 |
| Mean | 1587.10682 |
| MAD | 949.6950676 |
| Skewness | 1.588122545 |
| Sum | 344402.18 |
| Variance | 1527096.333 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1005.09 | 3 | 1.1% | |
| 1068.09 | 2 | 0.8% | |
| 2317.14 | 2 | 0.8% | |
| 1881.35 | 2 | 0.8% | |
| 2179.92 | 2 | 0.8% | |
| 1213.54 | 2 | 0.8% | |
| 1375.69 | 2 | 0.8% | |
| 2799.81 | 2 | 0.8% | |
| 1530.23 | 2 | 0.8% | |
| 960.76 | 1 | 0.4% | |
| Other values (197) | 197 | 74.3% | |
| (Missing) | 48 | 18.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 297.41 | 1 | 0.4% | |
| 339.08 | 1 | 0.4% | |
| 353.66 | 1 | 0.4% | |
| 365.15 | 1 | 0.4% | |
| 365.3 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 6347.86 | 1 | 0.4% | |
| 5985.49 | 1 | 0.4% | |
| 5985.39 | 1 | 0.4% | |
| 5463.12 | 1 | 0.4% | |
| 5261.19 | 1 | 0.4% |
faturamento_est_coligados
Numeric
| Distinct count | 62 |
|---|---|
| Unique (%) | 23.4% |
| Missing (%) | 72.1% |
| Missing (n) | 191 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 289284759.7 |
|---|---|
| Minimum | 123638.3984 |
| Maximum | 7559949122 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 123638.3984 |
|---|---|
| 5-th percentile | 210000 |
| Q1 | 807279.6094 |
| Median | 5192125.824 |
| Q3 | 55464072.81 |
| 95-th percentile | 710049020.8 |
| Maximum | 7559949122 |
| Range | 7559825483 |
| Interquartile range | 54656793.2 |
Descriptive statistics
| Standard deviation | 1135823648 |
|---|---|
| Coef of variation | 3.926316923 |
| Kurtosis | 28.39111034 |
| Mean | 289284759.7 |
| MAD | 458450248.1 |
| Skewness | 5.228047835 |
| Sum | 2.140707222e+10 |
| Variance | 1.290095359e+18 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 210000 | 10 | 3.8% | |
| 420000 | 3 | 1.1% | |
| 930000 | 2 | 0.8% | |
| 494553.5938 | 2 | 0.8% | |
| 5223030950 | 1 | 0.4% | |
| 84164409.75 | 1 | 0.4% | |
| 3727151686 | 1 | 0.4% | |
| 11282004 | 1 | 0.4% | |
| 928938553.6 | 1 | 0.4% | |
| 3449140.75 | 1 | 0.4% | |
| Other values (51) | 51 | 19.2% | |
| (Missing) | 191 | 72.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 123638.3984 | 1 | 0.4% | |
| 210000 | 10 | 3.8% | |
| 247276.7969 | 1 | 0.4% | |
| 288489.5938 | 1 | 0.4% | |
| 420000 | 3 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7559949122 | 1 | 0.4% | |
| 5223030950 | 1 | 0.4% | |
| 3727151686 | 1 | 0.4% | |
| 928938553.6 | 1 | 0.4% | |
| 592185426.2 | 1 | 0.4% |
faturamento_est_coligados_gp
Highly correlated
This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis
| Correlation | 0.9725637856 |
|---|
fl_antt
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 12 |
| Value | Count | Frequency (%) | |
| False | 253 | 95.5% | |
| True | 12 | 4.5% |
fl_email
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) | |
| False | 147 | 55.5% | |
| True | 118 | 44.5% |
fl_epp
Constant
This variable is constant and should be ignored for analysis
| Constant value | False |
|---|
fl_ltda
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 1 |
| Value | Count | Frequency (%) | |
| False | 264 | 99.6% | |
| True | 1 | 0.4% |
fl_matriz
Constant
This variable is constant and should be ignored for analysis
| Constant value | True |
|---|
fl_me
Constant
This variable is constant and should be ignored for analysis
| Constant value | False |
|---|
fl_mei
Constant
This variable is constant and should be ignored for analysis
| Constant value | False |
|---|
fl_optante_simei
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.8% |
| Missing (n) | 2 |
| False | |
|---|---|
| (Missing) | 2 |
| Value | Count | Frequency (%) | |
| False | 263 | 99.2% | |
| (Missing) | 2 | 0.8% |
fl_optante_simples
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 0.8% |
| Missing (n) | 2 |
| False | |
|---|---|
| True | 11 |
| (Missing) | 2 |
| Value | Count | Frequency (%) | |
| False | 252 | 95.1% | |
| True | 11 | 4.2% | |
| (Missing) | 2 | 0.8% |
fl_passivel_iss
Constant
This variable is constant and should be ignored for analysis
| Constant value | True |
|---|
fl_rm
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| NAO | |
|---|---|
| SIM |
| Value | Count | Frequency (%) | |
| NAO | 145 | 54.7% | |
| SIM | 120 | 45.3% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
fl_sa
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 5 |
| Value | Count | Frequency (%) | |
| False | 260 | 98.1% | |
| True | 5 | 1.9% |
fl_simples_irregular
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 1 |
| Value | Count | Frequency (%) | |
| False | 264 | 99.6% | |
| True | 1 | 0.4% |
fl_spa
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 10 |
| Value | Count | Frequency (%) | |
| False | 255 | 96.2% | |
| True | 10 | 3.8% |
fl_st_especial
Constant
This variable is constant and should be ignored for analysis
| Constant value | False |
|---|
fl_telefone
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) | |
| False | 133 | 50.2% | |
| True | 132 | 49.8% |
fl_veiculo
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| True | |
|---|---|
| False | 44 |
| Value | Count | Frequency (%) | |
| True | 221 | 83.4% | |
| False | 44 | 16.6% |
grau_instrucao_macro_analfabeto
Numeric
| Distinct count | 15 |
|---|---|
| Unique (%) | 5.7% |
| Missing (%) | 75.8% |
| Missing (n) | 201 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.21875 |
|---|---|
| Minimum | 1 |
| Maximum | 66 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 4.25 |
| 95-th percentile | 24 |
| Maximum | 66 |
| Range | 65 |
| Interquartile range | 3.25 |
Descriptive statistics
| Standard deviation | 12.3564375 |
|---|---|
| Coef of variation | 1.986964824 |
| Kurtosis | 15.39379909 |
| Mean | 6.21875 |
| MAD | 6.692382812 |
| Skewness | 3.805688551 |
| Sum | 398 |
| Variance | 152.6815476 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 24 | 9.1% | |
| 2 | 13 | 4.9% | |
| 3 | 8 | 3.0% | |
| 24 | 3 | 1.1% | |
| 4 | 3 | 1.1% | |
| 9 | 2 | 0.8% | |
| 8 | 2 | 0.8% | |
| 6 | 2 | 0.8% | |
| 7 | 2 | 0.8% | |
| 64 | 1 | 0.4% | |
| Other values (4) | 4 | 1.5% | |
| (Missing) | 201 | 75.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 24 | 9.1% | |
| 2 | 13 | 4.9% | |
| 3 | 8 | 3.0% | |
| 4 | 3 | 1.1% | |
| 5 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 66 | 1 | 0.4% | |
| 64 | 1 | 0.4% | |
| 33 | 1 | 0.4% | |
| 24 | 3 | 1.1% | |
| 12 | 1 | 0.4% |
grau_instrucao_macro_desconhecido
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
grau_instrucao_macro_escolaridade_fundamental
Numeric
| Distinct count | 130 |
|---|---|
| Unique (%) | 49.1% |
| Missing (%) | 4.5% |
| Missing (n) | 12 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 76.55335968 |
|---|---|
| Minimum | 1 |
| Maximum | 668 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1.6 |
| Q1 | 15 |
| Median | 45 |
| Q3 | 96 |
| 95-th percentile | 253 |
| Maximum | 668 |
| Range | 667 |
| Interquartile range | 81 |
Descriptive statistics
| Standard deviation | 105.8099999 |
|---|---|
| Coef of variation | 1.38217317 |
| Kurtosis | 11.1841695 |
| Mean | 76.55335968 |
| MAD | 66.39581934 |
| Skewness | 3.086906223 |
| Sum | 19368 |
| Variance | 11195.75607 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 13 | 4.9% | |
| 18 | 7 | 2.6% | |
| 19 | 6 | 2.3% | |
| 4 | 6 | 2.3% | |
| 7 | 6 | 2.3% | |
| 9 | 5 | 1.9% | |
| 17 | 5 | 1.9% | |
| 15 | 5 | 1.9% | |
| 54 | 5 | 1.9% | |
| 12 | 5 | 1.9% | |
| Other values (119) | 190 | 71.7% | |
| (Missing) | 12 | 4.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 13 | 4.9% | |
| 2 | 4 | 1.5% | |
| 3 | 4 | 1.5% | |
| 4 | 6 | 2.3% | |
| 5 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 668 | 1 | 0.4% | |
| 595 | 1 | 0.4% | |
| 576 | 1 | 0.4% | |
| 559 | 1 | 0.4% | |
| 499 | 1 | 0.4% |
grau_instrucao_macro_escolaridade_media
Numeric
| Distinct count | 196 |
|---|---|
| Unique (%) | 74.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 221.0264151 |
|---|---|
| Minimum | 4 |
| Maximum | 2447 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 23 |
| Q1 | 73 |
| Median | 140 |
| Q3 | 255 |
| 95-th percentile | 638.6 |
| Maximum | 2447 |
| Range | 2443 |
| Interquartile range | 182 |
Descriptive statistics
| Standard deviation | 273.2013411 |
|---|---|
| Coef of variation | 1.236057423 |
| Kurtosis | 22.39937334 |
| Mean | 221.0264151 |
| MAD | 162.8438305 |
| Skewness | 3.971661552 |
| Sum | 58572 |
| Variance | 74638.97278 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 134 | 4 | 1.5% | |
| 145 | 4 | 1.5% | |
| 49 | 4 | 1.5% | |
| 35 | 3 | 1.1% | |
| 122 | 3 | 1.1% | |
| 23 | 3 | 1.1% | |
| 117 | 3 | 1.1% | |
| 252 | 3 | 1.1% | |
| 40 | 3 | 1.1% | |
| 107 | 3 | 1.1% | |
| Other values (186) | 232 | 87.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 4 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| 6 | 2 | 0.8% | |
| 9 | 1 | 0.4% | |
| 11 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2447 | 1 | 0.4% | |
| 1662 | 1 | 0.4% | |
| 1581 | 1 | 0.4% | |
| 1193 | 2 | 0.8% | |
| 1164 | 1 | 0.4% |
grau_instrucao_macro_escolaridade_superior
Numeric
| Distinct count | 179 |
|---|---|
| Unique (%) | 67.5% |
| Missing (%) | 1.1% |
| Missing (n) | 3 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 174.0419847 |
|---|---|
| Minimum | 1 |
| Maximum | 2471 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 40.25 |
| Median | 90 |
| Q3 | 192.75 |
| 95-th percentile | 567.75 |
| Maximum | 2471 |
| Range | 2470 |
| Interquartile range | 152.5 |
Descriptive statistics
| Standard deviation | 272.8321487 |
|---|---|
| Coef of variation | 1.567622601 |
| Kurtosis | 26.49629512 |
| Mean | 174.0419847 |
| MAD | 155.0061768 |
| Skewness | 4.407661604 |
| Sum | 45599 |
| Variance | 74437.38137 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 3 | 7 | 2.6% | |
| 2 | 5 | 1.9% | |
| 56 | 4 | 1.5% | |
| 8 | 4 | 1.5% | |
| 7 | 4 | 1.5% | |
| 72 | 4 | 1.5% | |
| 63 | 4 | 1.5% | |
| 44 | 3 | 1.1% | |
| 13 | 3 | 1.1% | |
| 37 | 3 | 1.1% | |
| Other values (168) | 221 | 83.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 3 | 1.1% | |
| 2 | 5 | 1.9% | |
| 3 | 7 | 2.6% | |
| 4 | 2 | 0.8% | |
| 5 | 2 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2471 | 1 | 0.4% | |
| 1820 | 1 | 0.4% | |
| 1349 | 1 | 0.4% | |
| 1292 | 1 | 0.4% | |
| 1168 | 1 | 0.4% |
id
Categorical, Unique
| First 5 values |
|---|
| 001f6dfaefdbbe31deedb00996c8a87dd90342690611d6... |
| 01a586fca9efeab9f83ccab019962b0887882fac2625fe... |
| 03db1b36296ff895e6494a04d94795b247a78301dec8c0... |
| 04732bec03125a8a17f1191cbd7c6dc675628bbb87125c... |
| 04d34dcdee40a44560907165ab68f8e0ec771c0b94321f... |
| Last 5 values |
|---|
| fe796f2c60812f6fe96affa216079cf548daa25c3b72ea... |
| fea23f072675ec89f9b6ffd040777f5ff562c9d7623918... |
| feb9c97a3f694c22a919d9544c433da92d34d5717b43d5... |
| ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3... |
| ff9ff2ac35ec7cf5c7d5ed561010a53a953108110a3f5c... |
First 5 values
| Value | Count | Frequency (%) | |
| 001f6dfaefdbbe31deedb00996c8a87dd90342690611d6a0be7fbb19e4b5326c | 1 | 0.4% | |
| 01a586fca9efeab9f83ccab019962b0887882fac2625fe8363da97276c25e0f2 | 1 | 0.4% | |
| 03db1b36296ff895e6494a04d94795b247a78301dec8c0559bed9924436cc058 | 1 | 0.4% | |
| 04732bec03125a8a17f1191cbd7c6dc675628bbb87125c4f717b81d9c3bedd6e | 1 | 0.4% | |
| 04d34dcdee40a44560907165ab68f8e0ec771c0b94321f688d7a202d73f52673 | 1 | 0.4% |
Last 5 values
| Value | Count | Frequency (%) | |
| ff9ff2ac35ec7cf5c7d5ed561010a53a953108110a3f5cdcea92945d94b62d38 | 1 | 0.4% | |
| ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3ff71d663ecf8761bc6 | 1 | 0.4% | |
| feb9c97a3f694c22a919d9544c433da92d34d5717b43d54d88f543aa462958ae | 1 | 0.4% | |
| fea23f072675ec89f9b6ffd040777f5ff562c9d76239180a2e1786f917f3a52f | 1 | 0.4% | |
| fe796f2c60812f6fe96affa216079cf548daa25c3b72ea746d8ad2c25c131d1b | 1 | 0.4% |
idade_acima_de_58
Numeric
| Distinct count | 105 |
|---|---|
| Unique (%) | 39.6% |
| Missing (%) | 3.0% |
| Missing (n) | 8 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 53.91050584 |
|---|---|
| Minimum | 1 |
| Maximum | 1844 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 10 |
| Median | 27 |
| Q3 | 57 |
| 95-th percentile | 182.2 |
| Maximum | 1844 |
| Range | 1843 |
| Interquartile range | 47 |
Descriptive statistics
| Standard deviation | 131.1446443 |
|---|---|
| Coef of variation | 2.432636131 |
| Kurtosis | 138.7295025 |
| Mean | 53.91050584 |
| MAD | 50.67910188 |
| Skewness | 10.65083773 |
| Sum | 13855 |
| Variance | 17198.91774 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 2 | 9 | 3.4% | |
| 5 | 9 | 3.4% | |
| 17 | 8 | 3.0% | |
| 3 | 8 | 3.0% | |
| 6 | 8 | 3.0% | |
| 11 | 8 | 3.0% | |
| 12 | 8 | 3.0% | |
| 1 | 7 | 2.6% | |
| 4 | 6 | 2.3% | |
| 8 | 6 | 2.3% | |
| Other values (94) | 180 | 67.9% | |
| (Missing) | 8 | 3.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 7 | 2.6% | |
| 2 | 9 | 3.4% | |
| 3 | 8 | 3.0% | |
| 4 | 6 | 2.3% | |
| 5 | 9 | 3.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1844 | 1 | 0.4% | |
| 727 | 1 | 0.4% | |
| 307 | 1 | 0.4% | |
| 254 | 1 | 0.4% | |
| 235 | 1 | 0.4% |
idade_ate_18
Numeric
| Distinct count | 13 |
|---|---|
| Unique (%) | 4.9% |
| Missing (%) | 78.5% |
| Missing (n) | 208 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 4.403508772 |
|---|---|
| Minimum | 1 |
| Maximum | 56 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 5 |
| 95-th percentile | 10 |
| Maximum | 56 |
| Range | 55 |
| Interquartile range | 4 |
Descriptive statistics
| Standard deviation | 7.596661976 |
|---|---|
| Coef of variation | 1.725138377 |
| Kurtosis | 39.31533632 |
| Mean | 4.403508772 |
| MAD | 3.527854725 |
| Skewness | 5.8714155 |
| Sum | 251 |
| Variance | 57.70927318 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 16 | 6.0% | |
| 2 | 13 | 4.9% | |
| 3 | 10 | 3.8% | |
| 6 | 5 | 1.9% | |
| 7 | 3 | 1.1% | |
| 4 | 2 | 0.8% | |
| 10 | 2 | 0.8% | |
| 5 | 2 | 0.8% | |
| 8 | 1 | 0.4% | |
| 56 | 1 | 0.4% | |
| Other values (2) | 2 | 0.8% | |
| (Missing) | 208 | 78.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 16 | 6.0% | |
| 2 | 13 | 4.9% | |
| 3 | 10 | 3.8% | |
| 4 | 2 | 0.8% | |
| 5 | 2 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 56 | 1 | 0.4% | |
| 17 | 1 | 0.4% | |
| 10 | 2 | 0.8% | |
| 9 | 1 | 0.4% | |
| 8 | 1 | 0.4% |
idade_de_19_a_23
Numeric
| Distinct count | 43 |
|---|---|
| Unique (%) | 16.2% |
| Missing (%) | 28.7% |
| Missing (n) | 76 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 15.14285714 |
|---|---|
| Minimum | 1 |
| Maximum | 643 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| Median | 6 |
| Q3 | 16 |
| 95-th percentile | 37.8 |
| Maximum | 643 |
| Range | 642 |
| Interquartile range | 13 |
Descriptive statistics
| Standard deviation | 48.70171602 |
|---|---|
| Coef of variation | 3.216151058 |
| Kurtosis | 148.9475845 |
| Mean | 15.14285714 |
| MAD | 14.88737717 |
| Skewness | 11.64694624 |
| Sum | 2862 |
| Variance | 2371.857143 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 27 | 10.2% | |
| 2 | 19 | 7.2% | |
| 3 | 15 | 5.7% | |
| 4 | 13 | 4.9% | |
| 6 | 12 | 4.5% | |
| 5 | 12 | 4.5% | |
| 7 | 10 | 3.8% | |
| 10 | 8 | 3.0% | |
| 18 | 6 | 2.3% | |
| 19 | 5 | 1.9% | |
| Other values (32) | 62 | 23.4% | |
| (Missing) | 76 | 28.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 27 | 10.2% | |
| 2 | 19 | 7.2% | |
| 3 | 15 | 5.7% | |
| 4 | 13 | 4.9% | |
| 5 | 12 | 4.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 643 | 1 | 0.4% | |
| 139 | 1 | 0.4% | |
| 102 | 1 | 0.4% | |
| 65 | 1 | 0.4% | |
| 57 | 1 | 0.4% |
idade_de_24_a_28
Highly correlated
This variable is highly correlated with idade_de_19_a_23 and should be ignored for analysis
| Correlation | 0.9391201682 |
|---|
idade_de_29_a_33
Numeric
| Distinct count | 117 |
|---|---|
| Unique (%) | 44.2% |
| Missing (%) | 0.4% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 61.93560606 |
|---|---|
| Minimum | 2 |
| Maximum | 749 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 23.75 |
| Median | 40 |
| Q3 | 70.25 |
| 95-th percentile | 171.95 |
| Maximum | 749 |
| Range | 747 |
| Interquartile range | 46.5 |
Descriptive statistics
| Standard deviation | 81.47251993 |
|---|---|
| Coef of variation | 1.315439133 |
| Kurtosis | 29.98701438 |
| Mean | 61.93560606 |
| MAD | 44.9774449 |
| Skewness | 4.724876315 |
| Sum | 16351 |
| Variance | 6637.771503 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 32 | 7 | 2.6% | |
| 31 | 7 | 2.6% | |
| 11 | 7 | 2.6% | |
| 40 | 6 | 2.3% | |
| 22 | 6 | 2.3% | |
| 10 | 6 | 2.3% | |
| 27 | 6 | 2.3% | |
| 29 | 5 | 1.9% | |
| 25 | 5 | 1.9% | |
| 45 | 5 | 1.9% | |
| Other values (106) | 204 | 77.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 2 | 0.8% | |
| 3 | 1 | 0.4% | |
| 4 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| 6 | 2 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 749 | 1 | 0.4% | |
| 603 | 1 | 0.4% | |
| 517 | 1 | 0.4% | |
| 357 | 1 | 0.4% | |
| 325 | 1 | 0.4% |
idade_de_34_a_38
Numeric
| Distinct count | 123 |
|---|---|
| Unique (%) | 46.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 77.0754717 |
|---|---|
| Minimum | 1 |
| Maximum | 682 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 28 |
| Median | 45 |
| Q3 | 102 |
| 95-th percentile | 246 |
| Maximum | 682 |
| Range | 681 |
| Interquartile range | 74 |
Descriptive statistics
| Standard deviation | 85.41096043 |
|---|---|
| Coef of variation | 1.1081471 |
| Kurtosis | 14.19407178 |
| Mean | 77.0754717 |
| MAD | 55.99629761 |
| Skewness | 3.180956646 |
| Sum | 20425 |
| Variance | 7295.032161 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 28 | 8 | 3.0% | |
| 21 | 7 | 2.6% | |
| 27 | 6 | 2.3% | |
| 41 | 6 | 2.3% | |
| 33 | 6 | 2.3% | |
| 42 | 6 | 2.3% | |
| 34 | 6 | 2.3% | |
| 37 | 5 | 1.9% | |
| 22 | 5 | 1.9% | |
| 23 | 5 | 1.9% | |
| Other values (113) | 205 | 77.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.4% | |
| 3 | 2 | 0.8% | |
| 6 | 1 | 0.4% | |
| 9 | 2 | 0.8% | |
| 10 | 3 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 682 | 1 | 0.4% | |
| 535 | 1 | 0.4% | |
| 444 | 1 | 0.4% | |
| 375 | 1 | 0.4% | |
| 368 | 1 | 0.4% |
idade_de_39_a_43
Highly correlated
This variable is highly correlated with idade_de_34_a_38 and should be ignored for analysis
| Correlation | 0.9147291585 |
|---|
idade_de_44_a_48
Highly correlated
This variable is highly correlated with idade_de_39_a_43 and should be ignored for analysis
| Correlation | 0.9376949593 |
|---|
idade_de_49_a_53
Numeric
| Distinct count | 116 |
|---|---|
| Unique (%) | 43.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 53.50188679 |
|---|---|
| Minimum | 1 |
| Maximum | 532 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5.2 |
| Q1 | 19 |
| Median | 37 |
| Q3 | 64 |
| 95-th percentile | 163 |
| Maximum | 532 |
| Range | 531 |
| Interquartile range | 45 |
Descriptive statistics
| Standard deviation | 58.86696124 |
|---|---|
| Coef of variation | 1.100278229 |
| Kurtosis | 18.51098245 |
| Mean | 53.50188679 |
| MAD | 37.91572802 |
| Skewness | 3.374100194 |
| Sum | 14178 |
| Variance | 3465.319125 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 14 | 9 | 3.4% | |
| 21 | 6 | 2.3% | |
| 22 | 6 | 2.3% | |
| 31 | 6 | 2.3% | |
| 15 | 6 | 2.3% | |
| 30 | 6 | 2.3% | |
| 28 | 6 | 2.3% | |
| 7 | 6 | 2.3% | |
| 16 | 5 | 1.9% | |
| 8 | 5 | 1.9% | |
| Other values (106) | 204 | 77.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 2 | 0.8% | |
| 2 | 2 | 0.8% | |
| 3 | 2 | 0.8% | |
| 4 | 4 | 1.5% | |
| 5 | 4 | 1.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 532 | 1 | 0.4% | |
| 315 | 1 | 0.4% | |
| 266 | 1 | 0.4% | |
| 248 | 1 | 0.4% | |
| 235 | 1 | 0.4% |
idade_de_54_a_58
Highly correlated
This variable is highly correlated with idade_acima_de_58 and should be ignored for analysis
| Correlation | 0.9500453674 |
|---|
idade_emp_cat
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| > 20 | |
|---|---|
| 15 a 20 | 33 |
| 5 a 10 | 27 |
| Other values (3) | 29 |
| Value | Count | Frequency (%) | |
| > 20 | 176 | 66.4% | |
| 15 a 20 | 33 | 12.5% | |
| 5 a 10 | 27 | 10.2% | |
| 10 a 15 | 21 | 7.9% | |
| 1 a 5 | 7 | 2.6% | |
| <= 1 | 1 | 0.4% |
| Max length | 7 |
|---|---|
| Mean length | 4.841509434 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
idade_empresa_anos
Numeric
| Distinct count | 214 |
|---|---|
| Unique (%) | 80.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 27.76250194 |
|---|---|
| Minimum | 0.7616438356 |
| Maximum | 51.80821918 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.7616438356 |
|---|---|
| 5-th percentile | 6.068493151 |
| Q1 | 17.63835616 |
| Median | 24.0739726 |
| Q3 | 43.8 |
| 95-th percentile | 47.15780822 |
| Maximum | 51.80821918 |
| Range | 51.04657534 |
| Interquartile range | 26.16164384 |
Descriptive statistics
| Standard deviation | 14.11960273 |
|---|---|
| Coef of variation | 0.5085853846 |
| Kurtosis | -1.333726542 |
| Mean | 27.76250194 |
| MAD | 12.56690579 |
| Skewness | 0.02010867161 |
| Sum | 7357.063014 |
| Variance | 199.3631811 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 43.85479452 | 11 | 4.2% | |
| 21.83561644 | 9 | 3.4% | |
| 21.83287671 | 6 | 2.3% | |
| 43.86575342 | 6 | 2.3% | |
| 43.87671233 | 5 | 1.9% | |
| 43.86849315 | 4 | 1.5% | |
| 43.84657534 | 4 | 1.5% | |
| 43.83287671 | 3 | 1.1% | |
| 21.81643836 | 3 | 1.1% | |
| 43.8 | 3 | 1.1% | |
| Other values (204) | 211 | 79.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.7616438356 | 1 | 0.4% | |
| 1.002739726 | 1 | 0.4% | |
| 2.498630137 | 1 | 0.4% | |
| 2.6 | 1 | 0.4% | |
| 2.95890411 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 51.80821918 | 1 | 0.4% | |
| 51.49863014 | 1 | 0.4% | |
| 51.33424658 | 1 | 0.4% | |
| 50.92876712 | 1 | 0.4% | |
| 50.66027397 | 1 | 0.4% |
idade_maxima_coligadas
Highly correlated
This variable is highly correlated with coligada_mais_antiga_ativa and should be ignored for analysis
| Correlation | 0.990757127 |
|---|
idade_maxima_socios
Numeric
| Distinct count | 50 |
|---|---|
| Unique (%) | 18.9% |
| Missing (%) | 64.9% |
| Missing (n) | 172 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 54.96774194 |
|---|---|
| Minimum | 4 |
| Maximum | 90 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 31.6 |
| Q1 | 45 |
| Median | 54 |
| Q3 | 66 |
| 95-th percentile | 79.4 |
| Maximum | 90 |
| Range | 86 |
| Interquartile range | 21 |
Descriptive statistics
| Standard deviation | 15.46626878 |
|---|---|
| Coef of variation | 0.2813699132 |
| Kurtosis | 0.2465950917 |
| Mean | 54.96774194 |
| MAD | 12.35449185 |
| Skewness | -0.2249164359 |
| Sum | 5112 |
| Variance | 239.2054698 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 54 | 5 | 1.9% | |
| 50 | 4 | 1.5% | |
| 66 | 4 | 1.5% | |
| 49 | 4 | 1.5% | |
| 51 | 3 | 1.1% | |
| 33 | 3 | 1.1% | |
| 65 | 3 | 1.1% | |
| 47 | 3 | 1.1% | |
| 72 | 3 | 1.1% | |
| 55 | 3 | 1.1% | |
| Other values (39) | 58 | 21.9% | |
| (Missing) | 172 | 64.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 4 | 1 | 0.4% | |
| 27 | 1 | 0.4% | |
| 29 | 1 | 0.4% | |
| 30 | 1 | 0.4% | |
| 31 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 90 | 1 | 0.4% | |
| 86 | 1 | 0.4% | |
| 84 | 1 | 0.4% | |
| 82 | 1 | 0.4% | |
| 80 | 1 | 0.4% |
idade_media_coligadas
Numeric
| Distinct count | 77 |
|---|---|
| Unique (%) | 29.1% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 174.0541455 |
|---|---|
| Minimum | 2.3 |
| Maximum | 498.9666667 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2.3 |
|---|---|
| 5-th percentile | 24.475 |
| Q1 | 102.8291667 |
| Median | 156.6618056 |
| Q3 | 243.9458333 |
| 95-th percentile | 382.3583333 |
| Maximum | 498.9666667 |
| Range | 496.6666667 |
| Interquartile range | 141.1166667 |
Descriptive statistics
| Standard deviation | 108.4789161 |
|---|---|
| Coef of variation | 0.6232481036 |
| Kurtosis | 0.7833237045 |
| Mean | 174.0541455 |
| MAD | 85.83890719 |
| Skewness | 0.8317969626 |
| Sum | 13228.11506 |
| Variance | 11767.67524 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 139.6222222 | 1 | 0.4% | |
| 358.9416667 | 1 | 0.4% | |
| 495.95 | 1 | 0.4% | |
| 16.8 | 1 | 0.4% | |
| 44.06666667 | 1 | 0.4% | |
| 276.6333333 | 1 | 0.4% | |
| 21.2 | 1 | 0.4% | |
| 102.8666667 | 1 | 0.4% | |
| 116.3666667 | 1 | 0.4% | |
| 243.8166667 | 1 | 0.4% | |
| Other values (66) | 66 | 24.9% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2.3 | 1 | 0.4% | |
| 5.8 | 1 | 0.4% | |
| 16.8 | 1 | 0.4% | |
| 21.2 | 1 | 0.4% | |
| 25.56666667 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 498.9666667 | 1 | 0.4% | |
| 495.95 | 1 | 0.4% | |
| 408.4666667 | 1 | 0.4% | |
| 389.9833333 | 1 | 0.4% | |
| 379.8166667 | 1 | 0.4% |
idade_media_coligadas_ativas
Highly correlated
This variable is highly correlated with idade_media_coligadas and should be ignored for analysis
| Correlation | 0.9928275535 |
|---|
idade_media_coligadas_baixadas
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 99.6% |
| Missing (n) | 264 |
| 190.9 | 1 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 190.9 | 1 | 0.4% | |
| (Missing) | 264 | 99.6% |
| Max length | 5 |
|---|---|
| Mean length | 3.00754717 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
idade_media_socios
Numeric
| Distinct count | 63 |
|---|---|
| Unique (%) | 23.8% |
| Missing (%) | 64.9% |
| Missing (n) | 172 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 49.94940271 |
|---|---|
| Minimum | 4 |
| Maximum | 90 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 29.4 |
| Q1 | 41 |
| Median | 50 |
| Q3 | 61 |
| 95-th percentile | 70.3 |
| Maximum | 90 |
| Range | 86 |
| Interquartile range | 20 |
Descriptive statistics
| Standard deviation | 13.80293694 |
|---|---|
| Coef of variation | 0.2763383782 |
| Kurtosis | 0.5110116608 |
| Mean | 49.94940271 |
| MAD | 11.17281318 |
| Skewness | -0.1185136621 |
| Sum | 4645.294452 |
| Variance | 190.5210681 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 64 | 3 | 1.1% | |
| 63 | 3 | 1.1% | |
| 55 | 3 | 1.1% | |
| 47 | 3 | 1.1% | |
| 33 | 3 | 1.1% | |
| 50 | 3 | 1.1% | |
| 52 | 3 | 1.1% | |
| 69 | 2 | 0.8% | |
| 46.66666667 | 2 | 0.8% | |
| 64.5 | 2 | 0.8% | |
| Other values (52) | 66 | 24.9% | |
| (Missing) | 172 | 64.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 4 | 1 | 0.4% | |
| 27 | 2 | 0.8% | |
| 28 | 1 | 0.4% | |
| 28.5 | 1 | 0.4% | |
| 30 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 90 | 1 | 0.4% | |
| 75.66666667 | 1 | 0.4% | |
| 72 | 1 | 0.4% | |
| 71 | 1 | 0.4% | |
| 70.75 | 1 | 0.4% |
idade_minima_coligadas
Highly correlated
This variable is highly correlated with coligada_mais_nova_ativa and should be ignored for analysis
| Correlation | 1 |
|---|
idade_minima_socios
Highly correlated
This variable is highly correlated with idade_media_socios and should be ignored for analysis
| Correlation | 0.9030093563 |
|---|
max_faturamento_est_coligados
Highly correlated
This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis
| Correlation | 0.9484709664 |
|---|
max_faturamento_est_coligados_gp
Highly correlated
This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis
| Correlation | 0.9515331439 |
|---|
max_filiais_coligados
Numeric
| Distinct count | 15 |
|---|---|
| Unique (%) | 5.7% |
| Missing (%) | 86.4% |
| Missing (n) | 229 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 40.58333333 |
|---|---|
| Minimum | 1 |
| Maximum | 666 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1.75 |
| Median | 4 |
| Q3 | 7 |
| 95-th percentile | 178.25 |
| Maximum | 666 |
| Range | 665 |
| Interquartile range | 5.25 |
Descriptive statistics
| Standard deviation | 120.6691758 |
|---|---|
| Coef of variation | 2.973367783 |
| Kurtosis | 21.72829598 |
| Mean | 40.58333333 |
| MAD | 61.58333333 |
| Skewness | 4.4449895 |
| Sum | 1461 |
| Variance | 14561.05 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 9 | 3.4% | |
| 4 | 4 | 1.5% | |
| 3 | 4 | 1.5% | |
| 2 | 4 | 1.5% | |
| 7 | 3 | 1.1% | |
| 6 | 3 | 1.1% | |
| 5 | 2 | 0.8% | |
| 275 | 1 | 0.4% | |
| 666 | 1 | 0.4% | |
| 146 | 1 | 0.4% | |
| Other values (4) | 4 | 1.5% | |
| (Missing) | 229 | 86.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 9 | 3.4% | |
| 2 | 4 | 1.5% | |
| 3 | 4 | 1.5% | |
| 4 | 4 | 1.5% | |
| 5 | 2 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 666 | 1 | 0.4% | |
| 275 | 1 | 0.4% | |
| 146 | 1 | 0.4% | |
| 140 | 1 | 0.4% | |
| 76 | 1 | 0.4% |
max_funcionarios_coligados_gp
Highly correlated
This variable is highly correlated with max_filiais_coligados and should be ignored for analysis
| Correlation | 0.9312487825 |
|---|
max_meses_servicos
Numeric
| Distinct count | 228 |
|---|---|
| Unique (%) | 86.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 472.16 |
|---|---|
| Minimum | 6 |
| Maximum | 5099.066667 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 46.49333333 |
| Q1 | 251.5 |
| Median | 414.3333333 |
| Q3 | 521.3666667 |
| 95-th percentile | 641.3066667 |
| Maximum | 5099.066667 |
| Range | 5093.066667 |
| Interquartile range | 269.8666667 |
Descriptive statistics
| Standard deviation | 729.1793112 |
|---|---|
| Coef of variation | 1.544347914 |
| Kurtosis | 34.67675123 |
| Mean | 472.16 |
| MAD | 268.1125031 |
| Skewness | 5.815251087 |
| Sum | 125122.4 |
| Variance | 531702.4679 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 5099.066667 | 6 | 2.3% | |
| 507.2 | 5 | 1.9% | |
| 470.6666667 | 5 | 1.9% | |
| 265.6333333 | 5 | 1.9% | |
| 521.3666667 | 4 | 1.5% | |
| 265.6666667 | 4 | 1.5% | |
| 481.8333333 | 3 | 1.1% | |
| 495.0333333 | 3 | 1.1% | |
| 113.5333333 | 2 | 0.8% | |
| 123.6333333 | 2 | 0.8% | |
| Other values (218) | 226 | 85.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 6 | 1 | 0.4% | |
| 13.06666667 | 1 | 0.4% | |
| 26.23333333 | 1 | 0.4% | |
| 29.3 | 1 | 0.4% | |
| 30.33333333 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5099.066667 | 6 | 2.3% | |
| 804.4333333 | 1 | 0.4% | |
| 801.3666667 | 1 | 0.4% | |
| 707.3666667 | 1 | 0.4% | |
| 679.6333333 | 1 | 0.4% |
max_meses_servicos_all
Numeric
| Distinct count | 154 |
|---|---|
| Unique (%) | 58.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2134.504151 |
|---|---|
| Minimum | 13.06666667 |
| Maximum | 5099.066667 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 13.06666667 |
|---|---|
| 5-th percentile | 53.44666667 |
| Q1 | 257.3333333 |
| Median | 490.4333333 |
| Q3 | 5014.966667 |
| 95-th percentile | 5014.966667 |
| Maximum | 5099.066667 |
| Range | 5086 |
| Interquartile range | 4757.633333 |
Descriptive statistics
| Standard deviation | 2311.318392 |
|---|---|
| Coef of variation | 1.082836213 |
| Kurtosis | -1.797733588 |
| Mean | 2134.504151 |
| MAD | 2245.220169 |
| Skewness | 0.4491050719 |
| Sum | 565643.6 |
| Variance | 5342192.709 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 5014.966667 | 91 | 34.3% | |
| 5099.066667 | 6 | 2.3% | |
| 5064.7 | 5 | 1.9% | |
| 265.6666667 | 4 | 1.5% | |
| 265.6333333 | 4 | 1.5% | |
| 481.8333333 | 2 | 0.8% | |
| 373.2666667 | 2 | 0.8% | |
| 50.6 | 2 | 0.8% | |
| 387.4333333 | 2 | 0.8% | |
| 113.5333333 | 2 | 0.8% | |
| Other values (144) | 145 | 54.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 13.06666667 | 1 | 0.4% | |
| 26.23333333 | 1 | 0.4% | |
| 29.3 | 1 | 0.4% | |
| 29.36666667 | 1 | 0.4% | |
| 30.4 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5099.066667 | 6 | 2.3% | |
| 5065.733333 | 1 | 0.4% | |
| 5064.7 | 5 | 1.9% | |
| 5014.966667 | 91 | 34.3% | |
| 679.6333333 | 1 | 0.4% |
max_vl_folha_coligados
Numeric
| Distinct count | 56 |
|---|---|
| Unique (%) | 21.1% |
| Missing (%) | 78.1% |
| Missing (n) | 207 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 28700451.66 |
|---|---|
| Minimum | 0 |
| Maximum | 207712510 |
| Zeros (%) | 0.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 141153.84 |
| Q1 | 819104.4 |
| Median | 7871644.75 |
| Q3 | 31666885.5 |
| 95-th percentile | 165981456 |
| Maximum | 207712510 |
| Range | 207712510 |
| Interquartile range | 30847781.1 |
Descriptive statistics
| Standard deviation | 50411040.49 |
|---|---|
| Coef of variation | 1.756454605 |
| Kurtosis | 5.42770491 |
| Mean | 28700451.66 |
| MAD | 33899732.93 |
| Skewness | 2.437294092 |
| Sum | 1664626196 |
| Variance | 2.541273004e+15 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 247276.8 | 3 | 1.1% | |
| 370915.2 | 2 | 0.8% | |
| 13002638 | 1 | 0.4% | |
| 123432340 | 1 | 0.4% | |
| 75130936 | 1 | 0.4% | |
| 8531050 | 1 | 0.4% | |
| 33959348 | 1 | 0.4% | |
| 43953452 | 1 | 0.4% | |
| 8242560 | 1 | 0.4% | |
| 4224312 | 1 | 0.4% | |
| Other values (45) | 45 | 17.0% | |
| (Missing) | 207 | 78.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.4% | |
| 61819.2 | 1 | 0.4% | |
| 123638.4 | 1 | 0.4% | |
| 144244.8 | 1 | 0.4% | |
| 185457.6 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 207712510 | 1 | 0.4% | |
| 203920930 | 1 | 0.4% | |
| 171568880 | 1 | 0.4% | |
| 164995440 | 1 | 0.4% | |
| 123432340 | 1 | 0.4% |
max_vl_folha_coligados_gp
Numeric
| Distinct count | 58 |
|---|---|
| Unique (%) | 21.9% |
| Missing (%) | 77.7% |
| Missing (n) | 206 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 75770780.64 |
|---|---|
| Minimum | 61819.2 |
| Maximum | 1390128400 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 61819.2 |
|---|---|
| 5-th percentile | 181336.32 |
| Q1 | 1112745.6 |
| Median | 8242560 |
| Q3 | 41161284 |
| 95-th percentile | 285464576 |
| Maximum | 1390128400 |
| Range | 1390066581 |
| Interquartile range | 40048538.4 |
Descriptive statistics
| Standard deviation | 228286559.6 |
|---|---|
| Coef of variation | 3.012857433 |
| Kurtosis | 22.00973326 |
| Mean | 75770780.64 |
| MAD | 105783786.2 |
| Skewness | 4.554564643 |
| Sum | 4470476058 |
| Variance | 5.211475331e+16 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 247276.8 | 3 | 1.1% | |
| 6820718.5 | 1 | 0.4% | |
| 123432340 | 1 | 0.4% | |
| 8531050 | 1 | 0.4% | |
| 43953452 | 1 | 0.4% | |
| 8242560 | 1 | 0.4% | |
| 783043.2 | 1 | 0.4% | |
| 288489.6 | 1 | 0.4% | |
| 123617790 | 1 | 0.4% | |
| 44736496 | 1 | 0.4% | |
| Other values (47) | 47 | 17.7% | |
| (Missing) | 206 | 77.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 61819.2 | 1 | 0.4% | |
| 123638.4 | 1 | 0.4% | |
| 144244.8 | 1 | 0.4% | |
| 185457.6 | 1 | 0.4% | |
| 247276.8 | 3 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1390128400 | 1 | 0.4% | |
| 898068100 | 1 | 0.4% | |
| 678300860 | 1 | 0.4% | |
| 241816100 | 1 | 0.4% | |
| 177421100 | 1 | 0.4% |
media_faturamento_est_coligados
Highly correlated
This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis
| Correlation | 0.9075319591 |
|---|
media_faturamento_est_coligados_gp
Highly correlated
This variable is highly correlated with media_faturamento_est_coligados and should be ignored for analysis
| Correlation | 0.9465645673 |
|---|
media_filiais_coligados
Numeric
| Distinct count | 20 |
|---|---|
| Unique (%) | 7.5% |
| Missing (%) | 86.4% |
| Missing (n) | 229 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 8.003972262 |
|---|---|
| Minimum | 1 |
| Maximum | 63 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1.5 |
| Median | 2.1 |
| Q3 | 4.125 |
| 95-th percentile | 41.125 |
| Maximum | 63 |
| Range | 62 |
| Interquartile range | 2.625 |
Descriptive statistics
| Standard deviation | 14.36052137 |
|---|---|
| Coef of variation | 1.794174305 |
| Kurtosis | 7.114313903 |
| Mean | 8.003972262 |
| MAD | 9.268296501 |
| Skewness | 2.722577445 |
| Sum | 288.1430014 |
| Variance | 206.2245741 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 9 | 3.4% | |
| 2 | 8 | 3.0% | |
| 4 | 3 | 1.1% | |
| 2.2 | 1 | 0.4% | |
| 10 | 1 | 0.4% | |
| 25 | 1 | 0.4% | |
| 2.5 | 1 | 0.4% | |
| 63 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 1.666666667 | 1 | 0.4% | |
| Other values (9) | 9 | 3.4% | |
| (Missing) | 229 | 86.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 9 | 3.4% | |
| 1.666666667 | 1 | 0.4% | |
| 2 | 8 | 3.0% | |
| 2.2 | 1 | 0.4% | |
| 2.363636364 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 63 | 1 | 0.4% | |
| 49 | 1 | 0.4% | |
| 38.5 | 1 | 0.4% | |
| 25 | 1 | 0.4% | |
| 24 | 1 | 0.4% |
media_funcionarios_coligados_gp
Numeric
| Distinct count | 56 |
|---|---|
| Unique (%) | 21.1% |
| Missing (%) | 76.2% |
| Missing (n) | 202 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 243.245227 |
|---|---|
| Minimum | 0 |
| Maximum | 4398.611111 |
| Zeros (%) | 1.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.1 |
| Q1 | 7.666666667 |
| Median | 45 |
| Q3 | 150 |
| 95-th percentile | 846.658 |
| Maximum | 4398.611111 |
| Range | 4398.611111 |
| Interquartile range | 142.3333333 |
Descriptive statistics
| Standard deviation | 652.2327083 |
|---|---|
| Coef of variation | 2.681379266 |
| Kurtosis | 28.05675891 |
| Mean | 243.245227 |
| MAD | 311.8019896 |
| Skewness | 4.962912511 |
| Sum | 15324.4493 |
| Variance | 425407.5058 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 4 | 4 | 1.5% | |
| 0 | 4 | 1.5% | |
| 10 | 2 | 0.8% | |
| 3 | 2 | 0.8% | |
| 25 | 1 | 0.4% | |
| 45 | 1 | 0.4% | |
| 119 | 1 | 0.4% | |
| 28.25 | 1 | 0.4% | |
| 77 | 1 | 0.4% | |
| 37 | 1 | 0.4% | |
| Other values (45) | 45 | 17.0% | |
| (Missing) | 202 | 76.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 4 | 1.5% | |
| 1 | 1 | 0.4% | |
| 2 | 1 | 0.4% | |
| 3 | 2 | 0.8% | |
| 4 | 4 | 1.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4398.611111 | 1 | 0.4% | |
| 2112 | 1 | 0.4% | |
| 1878.333333 | 1 | 0.4% | |
| 851.4333333 | 1 | 0.4% | |
| 803.68 | 1 | 0.4% |
media_meses_servicos
Numeric
| Distinct count | 265 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 129.43489 |
|---|---|
| Minimum | 5.947005208 |
| Maximum | 353.9549383 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 5.947005208 |
|---|---|
| 5-th percentile | 22.16216747 |
| Q1 | 58.73533333 |
| Median | 138.3858912 |
| Q3 | 182.0918301 |
| 95-th percentile | 234.5757388 |
| Maximum | 353.9549383 |
| Range | 348.0079331 |
| Interquartile range | 123.3564967 |
Descriptive statistics
| Standard deviation | 73.44083954 |
|---|---|
| Coef of variation | 0.5673960053 |
| Kurtosis | -0.6431313459 |
| Mean | 129.43489 |
| MAD | 62.156147 |
| Skewness | 0.1463746749 |
| Sum | 34300.24586 |
| Variance | 5393.556912 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 47.86570697 | 1 | 0.4% | |
| 146.8411438 | 1 | 0.4% | |
| 152.2654971 | 1 | 0.4% | |
| 30.82928647 | 1 | 0.4% | |
| 223.3868766 | 1 | 0.4% | |
| 235.2654229 | 1 | 0.4% | |
| 160.5006369 | 1 | 0.4% | |
| 58.73533333 | 1 | 0.4% | |
| 99.72819549 | 1 | 0.4% | |
| 121.8192187 | 1 | 0.4% | |
| Other values (255) | 255 | 96.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 5.947005208 | 1 | 0.4% | |
| 10.96567901 | 1 | 0.4% | |
| 11.98393574 | 1 | 0.4% | |
| 14.42028986 | 1 | 0.4% | |
| 15.14791667 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 353.9549383 | 1 | 0.4% | |
| 319.0152482 | 1 | 0.4% | |
| 313.4891775 | 1 | 0.4% | |
| 310.8166667 | 1 | 0.4% | |
| 288.7471564 | 1 | 0.4% |
media_meses_servicos_all
Numeric
| Distinct count | 265 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 120.2838588 |
|---|---|
| Minimum | 6.115453384 |
| Maximum | 576.6240637 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 6.115453384 |
|---|---|
| 5-th percentile | 16.11094299 |
| Q1 | 39.68535147 |
| Median | 110.7311828 |
| Q3 | 173.4749593 |
| 95-th percentile | 260.4524049 |
| Maximum | 576.6240637 |
| Range | 570.5086103 |
| Interquartile range | 133.7896079 |
Descriptive statistics
| Standard deviation | 92.93103827 |
|---|---|
| Coef of variation | 0.7725977467 |
| Kurtosis | 3.980982333 |
| Mean | 120.2838588 |
| MAD | 71.72502269 |
| Skewness | 1.453669429 |
| Sum | 31875.22258 |
| Variance | 8636.177875 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 295.4055381 | 1 | 0.4% | |
| 43.00790988 | 1 | 0.4% | |
| 43.70350877 | 1 | 0.4% | |
| 177.7679012 | 1 | 0.4% | |
| 10.88125 | 1 | 0.4% | |
| 35.87798085 | 1 | 0.4% | |
| 192.4009315 | 1 | 0.4% | |
| 93.25028011 | 1 | 0.4% | |
| 137.1910522 | 1 | 0.4% | |
| 30.17237164 | 1 | 0.4% | |
| Other values (255) | 255 | 96.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 6.115453384 | 1 | 0.4% | |
| 8.896975875 | 1 | 0.4% | |
| 8.910264947 | 1 | 0.4% | |
| 9.274385965 | 1 | 0.4% | |
| 10.88125 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 576.6240637 | 1 | 0.4% | |
| 552.7651578 | 1 | 0.4% | |
| 519.2097977 | 1 | 0.4% | |
| 367.717433 | 1 | 0.4% | |
| 361.3688113 | 1 | 0.4% |
media_vl_folha_coligados
Numeric
| Distinct count | 57 |
|---|---|
| Unique (%) | 21.5% |
| Missing (%) | 78.1% |
| Missing (n) | 207 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9142780.315 |
|---|---|
| Minimum | 0 |
| Maximum | 123432336 |
| Zeros (%) | 0.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 141153.8371 |
| Q1 | 489402 |
| Median | 4234615.3 |
| Q3 | 10169258.7 |
| 95-th percentile | 26650521.97 |
| Maximum | 123432336 |
| Range | 123432336 |
| Interquartile range | 9679856.695 |
Descriptive statistics
| Standard deviation | 17729689.14 |
|---|---|
| Coef of variation | 1.939201045 |
| Kurtosis | 30.81501375 |
| Mean | 9142780.315 |
| MAD | 9466681.82 |
| Skewness | 5.006155602 |
| Sum | 530281258.2 |
| Variance | 3.143418771e+14 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 247276.7969 | 3 | 1.1% | |
| 597585.625 | 1 | 0.4% | |
| 216367.1953 | 1 | 0.4% | |
| 4244918.6 | 1 | 0.4% | |
| 4224312 | 1 | 0.4% | |
| 13991745.79 | 1 | 0.4% | |
| 2720044.75 | 1 | 0.4% | |
| 5472716.419 | 1 | 0.4% | |
| 61819.19922 | 1 | 0.4% | |
| 36695875.81 | 1 | 0.4% | |
| Other values (46) | 46 | 17.4% | |
| (Missing) | 207 | 78.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.4% | |
| 61819.19922 | 1 | 0.4% | |
| 123638.3984 | 1 | 0.4% | |
| 144244.7969 | 1 | 0.4% | |
| 185457.5938 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 123432336 | 1 | 0.4% | |
| 38369116 | 1 | 0.4% | |
| 36695875.81 | 1 | 0.4% | |
| 24877812.46 | 1 | 0.4% | |
| 24383431.91 | 1 | 0.4% |
media_vl_folha_coligados_gp
Numeric
| Distinct count | 58 |
|---|---|
| Unique (%) | 21.9% |
| Missing (%) | 77.7% |
| Missing (n) | 206 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 14371416.38 |
|---|---|
| Minimum | 61819.19922 |
| Maximum | 123432336 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 61819.19922 |
|---|---|
| 5-th percentile | 181336.3141 |
| Q1 | 723799.7866 |
| Median | 4718865.566 |
| Q3 | 11292306.88 |
| 95-th percentile | 63808925.32 |
| Maximum | 123432336 |
| Range | 123370516.8 |
| Interquartile range | 10568507.09 |
Descriptive statistics
| Standard deviation | 25761432.24 |
|---|---|
| Coef of variation | 1.792546507 |
| Kurtosis | 8.032650745 |
| Mean | 14371416.38 |
| MAD | 16632802.19 |
| Skewness | 2.787974974 |
| Sum | 847913566.5 |
| Variance | 6.636513912e+14 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 247276.7969 | 3 | 1.1% | |
| 20716300.79 | 1 | 0.4% | |
| 8531050 | 1 | 0.4% | |
| 783043.1875 | 1 | 0.4% | |
| 18126763.12 | 1 | 0.4% | |
| 216367.1953 | 1 | 0.4% | |
| 61812331.12 | 1 | 0.4% | |
| 2720044.75 | 1 | 0.4% | |
| 61819.19922 | 1 | 0.4% | |
| 8798932.779 | 1 | 0.4% | |
| Other values (47) | 47 | 17.7% | |
| (Missing) | 206 | 77.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 61819.19922 | 1 | 0.4% | |
| 123638.3984 | 1 | 0.4% | |
| 144244.7969 | 1 | 0.4% | |
| 185457.5938 | 1 | 0.4% | |
| 216367.1953 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 123432336 | 1 | 0.4% | |
| 110241817.5 | 1 | 0.4% | |
| 81778273.11 | 1 | 0.4% | |
| 61812331.12 | 1 | 0.4% | |
| 52856273.81 | 1 | 0.4% |
meses_ultima_contratacaco
Numeric
| Distinct count | 137 |
|---|---|
| Unique (%) | 51.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 19.38792453 |
|---|---|
| Minimum | 1.966666667 |
| Maximum | 112.1666667 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1.966666667 |
|---|---|
| 5-th percentile | 2.066666667 |
| Q1 | 2.933333333 |
| Median | 23.2 |
| Q3 | 27.9 |
| 95-th percentile | 42.51333333 |
| Maximum | 112.1666667 |
| Range | 110.2 |
| Interquartile range | 24.96666667 |
Descriptive statistics
| Standard deviation | 16.07359668 |
|---|---|
| Coef of variation | 0.8290519522 |
| Kurtosis | 4.60609407 |
| Mean | 19.38792453 |
| MAD | 12.8650566 |
| Skewness | 1.295618532 |
| Sum | 5137.8 |
| Variance | 258.3605102 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 2.933333333 | 16 | 6.0% | |
| 23.2 | 13 | 4.9% | |
| 24.2 | 10 | 3.8% | |
| 2.066666667 | 10 | 3.8% | |
| 2.3 | 7 | 2.6% | |
| 30.33333333 | 6 | 2.3% | |
| 2.533333333 | 6 | 2.3% | |
| 2.2 | 5 | 1.9% | |
| 2.033333333 | 5 | 1.9% | |
| 28.3 | 5 | 1.9% | |
| Other values (127) | 182 | 68.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.966666667 | 3 | 1.1% | |
| 2 | 1 | 0.4% | |
| 2.033333333 | 5 | 1.9% | |
| 2.066666667 | 10 | 3.8% | |
| 2.166666667 | 2 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 112.1666667 | 1 | 0.4% | |
| 88.16666667 | 1 | 0.4% | |
| 70.86666667 | 1 | 0.4% | |
| 68.9 | 1 | 0.4% | |
| 65.83333333 | 1 | 0.4% |
min_faturamento_est_coligados
Numeric
| Distinct count | 26 |
|---|---|
| Unique (%) | 9.8% |
| Missing (%) | 72.1% |
| Missing (n) | 191 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1901396.8 |
|---|---|
| Minimum | 50000 |
| Maximum | 32506596 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 50000 |
|---|---|
| 5-th percentile | 123638.4 |
| Q1 | 210000 |
| Median | 210000 |
| Q3 | 494553.6 |
| 95-th percentile | 16595879.4 |
| Maximum | 32506596 |
| Range | 32456596 |
| Interquartile range | 284553.6 |
Descriptive statistics
| Standard deviation | 5720661.001 |
|---|---|
| Coef of variation | 3.008662369 |
| Kurtosis | 15.21235622 |
| Mean | 1901396.8 |
| MAD | 2850976.173 |
| Skewness | 3.898271231 |
| Sum | 140703363.2 |
| Variance | 3.272596229e+13 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 210000 | 39 | 14.7% | |
| 123638.4 | 8 | 3.0% | |
| 494553.6 | 3 | 1.1% | |
| 618192 | 2 | 0.8% | |
| 930000 | 2 | 0.8% | |
| 21327624 | 1 | 0.4% | |
| 1195171.2 | 1 | 0.4% | |
| 3008534.5 | 1 | 0.4% | |
| 32506596 | 1 | 0.4% | |
| 16433604 | 1 | 0.4% | |
| Other values (15) | 15 | 5.7% | |
| (Missing) | 191 | 72.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 50000 | 1 | 0.4% | |
| 123638.4 | 8 | 3.0% | |
| 164851.2 | 1 | 0.4% | |
| 185457.6 | 1 | 0.4% | |
| 206064 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 32506596 | 1 | 0.4% | |
| 23182200 | 1 | 0.4% | |
| 21327624 | 1 | 0.4% | |
| 16897248 | 1 | 0.4% | |
| 16433604 | 1 | 0.4% |
min_faturamento_est_coligados_gp
Highly correlated
This variable is highly correlated with min_faturamento_est_coligados and should be ignored for analysis
| Correlation | 0.9844779291 |
|---|
min_filiais_coligados
Numeric
| Distinct count | 8 |
|---|---|
| Unique (%) | 3.0% |
| Missing (%) | 86.4% |
| Missing (n) | 229 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.972222222 |
|---|---|
| Minimum | 1 |
| Maximum | 49 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 5.25 |
| Maximum | 49 |
| Range | 48 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 7.983862692 |
|---|---|
| Coef of variation | 2.686159411 |
| Kurtosis | 34.19743454 |
| Mean | 2.972222222 |
| MAD | 2.899691358 |
| Skewness | 5.787633327 |
| Sum | 107 |
| Variance | 63.74206349 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 24 | 9.1% | |
| 2 | 5 | 1.9% | |
| 3 | 3 | 1.1% | |
| 49 | 1 | 0.4% | |
| 4 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| (Missing) | 229 | 86.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 24 | 9.1% | |
| 2 | 5 | 1.9% | |
| 3 | 3 | 1.1% | |
| 4 | 1 | 0.4% | |
| 5 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 49 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| 4 | 1 | 0.4% | |
| 3 | 3 | 1.1% |
min_funcionarios_coligados_gp
Highly correlated
This variable is highly correlated with min_filiais_coligados and should be ignored for analysis
| Correlation | 0.916066893 |
|---|
min_meses_servicos
Highly correlated
This variable is highly correlated with meses_ultima_contratacaco and should be ignored for analysis
| Correlation | 0.9567491686 |
|---|
min_meses_servicos_all
Numeric
| Distinct count | 125 |
|---|---|
| Unique (%) | 47.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.331194969 |
|---|---|
| Minimum | -11.7 |
| Maximum | 66.93333333 |
| Zeros (%) | 7.2% |
Quantile statistics
| Minimum | -11.7 |
|---|---|
| 5-th percentile | -6.1 |
| Q1 | -0.6333333333 |
| Median | 0 |
| Q3 | 1.666666667 |
| 95-th percentile | 10.87333333 |
| Maximum | 66.93333333 |
| Range | 78.63333333 |
| Interquartile range | 2.3 |
Descriptive statistics
| Standard deviation | 7.099983375 |
|---|---|
| Coef of variation | 5.333541324 |
| Kurtosis | 33.65754482 |
| Mean | 1.331194969 |
| MAD | 3.590815237 |
| Skewness | 4.578945101 |
| Sum | 352.7666667 |
| Variance | 50.40976393 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 19 | 7.2% | |
| 1 | 14 | 5.3% | |
| -0.5333333333 | 9 | 3.4% | |
| -0.03333333333 | 8 | 3.0% | |
| -0.7333333333 | 6 | 2.3% | |
| 0.2 | 6 | 2.3% | |
| 2.033333333 | 5 | 1.9% | |
| -0.4 | 5 | 1.9% | |
| 8.133333333 | 5 | 1.9% | |
| 3.033333333 | 4 | 1.5% | |
| Other values (115) | 184 | 69.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -11.7 | 1 | 0.4% | |
| -11.2 | 2 | 0.8% | |
| -11.16666667 | 1 | 0.4% | |
| -10.16666667 | 1 | 0.4% | |
| -9.833333333 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 66.93333333 | 1 | 0.4% | |
| 44.2 | 1 | 0.4% | |
| 27.7 | 1 | 0.4% | |
| 27.5 | 1 | 0.4% | |
| 26.7 | 1 | 0.4% |
min_vl_folha_coligados
Highly correlated
This variable is highly correlated with min_funcionarios_coligados_gp and should be ignored for analysis
| Correlation | 0.9989755332 |
|---|
min_vl_folha_coligados_gp
Highly correlated
This variable is highly correlated with min_vl_folha_coligados and should be ignored for analysis
| Correlation | 0.9991732114 |
|---|
natureza_juridica_macro
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| OUTROS | |
|---|---|
| ENTIDADES EMPRESARIAIS | |
| ADMINISTRACAO PUBLICA |
| Value | Count | Frequency (%) | |
| OUTROS | 128 | 48.3% | |
| ENTIDADES EMPRESARIAIS | 73 | 27.5% | |
| ADMINISTRACAO PUBLICA | 47 | 17.7% | |
| ENTIDADES SEM FINS LUCRATIVOS | 17 | 6.4% |
| Max length | 29 |
|---|---|
| Mean length | 14.54339623 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_divisao
Categorical
| Distinct count | 26 |
|---|---|
| Unique (%) | 9.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | |
|---|---|
| EDUCACAO | 22 |
| SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS | 18 |
| Other values (23) |
| Value | Count | Frequency (%) | |
| ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 150 | 56.6% | |
| EDUCACAO | 22 | 8.3% | |
| SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS | 18 | 6.8% | |
| ATIVIDADES DE ATENCAO A SAUDE HUMANA | 12 | 4.5% | |
| TRANSPORTE TERRESTRE | 12 | 4.5% | |
| SELECAO AGENCIAMENTO E LOCACAO DE MAO DE OBRA | 6 | 2.3% | |
| SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ANALISES TECNICAS | 4 | 1.5% | |
| ALIMENTACAO | 4 | 1.5% | |
| ATIVIDADES DE VIGILANCIA SEGURANCA E INVESTIGACAO | 4 | 1.5% | |
| SERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO E OUTROS SERVICOS PRESTADOS PRINCIPALMENTE AS EMPRESAS | 4 | 1.5% | |
| Other values (16) | 29 | 10.9% |
| Max length | 120 |
|---|---|
| Mean length | 43.50943396 |
| Min length | 8 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_meso_regiao
Categorical
| Distinct count | 20 |
|---|---|
| Unique (%) | 7.5% |
| Missing (%) | 9.1% |
| Missing (n) | 24 |
| NORTE MARANHENSE | |
|---|---|
| CENTRO AMAZONENSE | |
| CENTRO NORTE PIAUIENSE | |
| Other values (16) | |
| (Missing) | 24 |
| Value | Count | Frequency (%) | |
| NORTE MARANHENSE | 41 | 15.5% | |
| CENTRO AMAZONENSE | 39 | 14.7% | |
| CENTRO NORTE PIAUIENSE | 31 | 11.7% | |
| LESTE POTIGUAR | 23 | 8.7% | |
| VALE DO ACRE | 21 | 7.9% | |
| OESTE POTIGUAR | 13 | 4.9% | |
| SUDESTE PIAUIENSE | 11 | 4.2% | |
| CENTRO MARANHENSE | 11 | 4.2% | |
| OESTE MARANHENSE | 10 | 3.8% | |
| AGRESTE POTIGUAR | 8 | 3.0% | |
| Other values (9) | 33 | 12.5% | |
| (Missing) | 24 | 9.1% |
| Max length | 22 |
|---|---|
| Mean length | 15.16226415 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_micro_regiao
Categorical
| Distinct count | 57 |
|---|---|
| Unique (%) | 21.5% |
| Missing (%) | 9.1% |
| Missing (n) | 24 |
| MANAUS | |
|---|---|
| AGLOMERACAO URBANA DE SAO LUIS | |
| TERESINA | 21 |
| Other values (53) | |
| (Missing) | 24 |
| Value | Count | Frequency (%) | |
| MANAUS | 38 | 14.3% | |
| AGLOMERACAO URBANA DE SAO LUIS | 32 | 12.1% | |
| TERESINA | 21 | 7.9% | |
| RIO BRANCO | 19 | 7.2% | |
| NATAL | 18 | 6.8% | |
| MEDIO MEARIM | 6 | 2.3% | |
| PINDARE | 6 | 2.3% | |
| PICOS | 6 | 2.3% | |
| ALTO MEDIO CANINDE | 5 | 1.9% | |
| CAMPO MAIOR | 5 | 1.9% | |
| Other values (46) | 85 | 32.1% | |
| (Missing) | 24 | 9.1% |
| Max length | 30 |
|---|---|
| Mean length | 12.34716981 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_segmento
Categorical
| Distinct count | 13 |
|---|---|
| Unique (%) | 4.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | |
|---|---|
| ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES | |
| EDUCACAO | 22 |
| Other values (10) |
| Value | Count | Frequency (%) | |
| ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 150 | 56.6% | |
| ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES | 35 | 13.2% | |
| EDUCACAO | 22 | 8.3% | |
| SAUDE HUMANA E SERVICOS SOCIAIS | 14 | 5.3% | |
| TRANSPORTE ARMAZENAGEM E CORREIO | 14 | 5.3% | |
| AGUA ESGOTO ATIVIDADES DE GESTAO DE RESIDUOS E DESCONTAMINACAO | 5 | 1.9% | |
| ATIVIDADES FINANCEIRAS DE SEGUROS E SERVICOS RELACIONADOS | 5 | 1.9% | |
| ALOJAMENTO E ALIMENTACAO | 5 | 1.9% | |
| ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS | 5 | 1.9% | |
| OUTRAS ATIVIDADES DE SERVICOS | 4 | 1.5% | |
| Other values (3) | 6 | 2.3% |
| Max length | 62 |
|---|---|
| Mean length | 42.62641509 |
| Min length | 8 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nu_meses_rescencia
Numeric
| Distinct count | 12 |
|---|---|
| Unique (%) | 4.5% |
| Missing (%) | 0.4% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 24.73863636 |
|---|---|
| Minimum | 9 |
| Maximum | 49 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 9 |
|---|---|
| 5-th percentile | 22 |
| Q1 | 23 |
| Median | 23 |
| Q3 | 23 |
| 95-th percentile | 48 |
| Maximum | 49 |
| Range | 40 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 6.241333431 |
|---|---|
| Coef of variation | 0.2522909242 |
| Kurtosis | 9.907271187 |
| Mean | 24.73863636 |
| MAD | 3.192493113 |
| Skewness | 3.29038472 |
| Sum | 6531 |
| Variance | 38.954243 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 23 | 205 | 77.4% | |
| 48 | 15 | 5.7% | |
| 26 | 13 | 4.9% | |
| 22 | 12 | 4.5% | |
| 24 | 7 | 2.6% | |
| 27 | 4 | 1.5% | |
| 21 | 3 | 1.1% | |
| 25 | 2 | 0.8% | |
| 9 | 1 | 0.4% | |
| 47 | 1 | 0.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 9 | 1 | 0.4% | |
| 21 | 3 | 1.1% | |
| 22 | 12 | 4.5% | |
| 23 | 205 | 77.4% | |
| 24 | 7 | 2.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 49 | 1 | 0.4% | |
| 48 | 15 | 5.7% | |
| 47 | 1 | 0.4% | |
| 27 | 4 | 1.5% | |
| 26 | 13 | 4.9% |
percent_func_genero_fem
Numeric
| Distinct count | 261 |
|---|---|
| Unique (%) | 98.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 52.97943396 |
|---|---|
| Minimum | 0.36 |
| Maximum | 86.06 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.36 |
|---|---|
| 5-th percentile | 13.274 |
| Q1 | 43.38 |
| Median | 57.51 |
| Q3 | 67.71 |
| 95-th percentile | 76.994 |
| Maximum | 86.06 |
| Range | 85.7 |
| Interquartile range | 24.33 |
Descriptive statistics
| Standard deviation | 19.04481282 |
|---|---|
| Coef of variation | 0.3594755814 |
| Kurtosis | 0.1213098667 |
| Mean | 52.97943396 |
| MAD | 15.19650267 |
| Skewness | -0.8547835709 |
| Sum | 14039.55 |
| Variance | 362.7048955 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 63.38 | 2 | 0.8% | |
| 72.93 | 2 | 0.8% | |
| 69.21 | 2 | 0.8% | |
| 50 | 2 | 0.8% | |
| 68.02 | 1 | 0.4% | |
| 49.35 | 1 | 0.4% | |
| 52.31 | 1 | 0.4% | |
| 68.63 | 1 | 0.4% | |
| 63.36 | 1 | 0.4% | |
| 74.03 | 1 | 0.4% | |
| Other values (251) | 251 | 94.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.36 | 1 | 0.4% | |
| 3 | 1 | 0.4% | |
| 3.47 | 1 | 0.4% | |
| 4.74 | 1 | 0.4% | |
| 4.98 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 86.06 | 1 | 0.4% | |
| 84.44 | 1 | 0.4% | |
| 83.22 | 1 | 0.4% | |
| 83.1 | 1 | 0.4% | |
| 82.91 | 1 | 0.4% |
percent_func_genero_masc
Numeric
| Distinct count | 261 |
|---|---|
| Unique (%) | 98.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 47.02056604 |
|---|---|
| Minimum | 13.94 |
| Maximum | 99.64 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 13.94 |
|---|---|
| 5-th percentile | 23.006 |
| Q1 | 32.29 |
| Median | 42.49 |
| Q3 | 56.62 |
| 95-th percentile | 86.726 |
| Maximum | 99.64 |
| Range | 85.7 |
| Interquartile range | 24.33 |
Descriptive statistics
| Standard deviation | 19.04481282 |
|---|---|
| Coef of variation | 0.4050315517 |
| Kurtosis | 0.1213098667 |
| Mean | 47.02056604 |
| MAD | 15.19650267 |
| Skewness | 0.8547835709 |
| Sum | 12460.45 |
| Variance | 362.7048955 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 27.07 | 2 | 0.8% | |
| 36.62 | 2 | 0.8% | |
| 30.79 | 2 | 0.8% | |
| 50 | 2 | 0.8% | |
| 52.76 | 1 | 0.4% | |
| 16.78 | 1 | 0.4% | |
| 64.01 | 1 | 0.4% | |
| 74.22 | 1 | 0.4% | |
| 36.64 | 1 | 0.4% | |
| 50.65 | 1 | 0.4% | |
| Other values (251) | 251 | 94.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 13.94 | 1 | 0.4% | |
| 15.56 | 1 | 0.4% | |
| 16.78 | 1 | 0.4% | |
| 16.9 | 1 | 0.4% | |
| 17.09 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 99.64 | 1 | 0.4% | |
| 97 | 1 | 0.4% | |
| 96.53 | 1 | 0.4% | |
| 95.26 | 1 | 0.4% | |
| 95.02 | 1 | 0.4% |
qt_admitidos
Numeric
| Distinct count | 241 |
|---|---|
| Unique (%) | 90.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 915.8641509 |
|---|---|
| Minimum | 83 |
| Maximum | 7961 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 83 |
|---|---|
| 5-th percentile | 177 |
| Q1 | 355 |
| Median | 582 |
| Q3 | 983 |
| 95-th percentile | 2839.4 |
| Maximum | 7961 |
| Range | 7878 |
| Interquartile range | 628 |
Descriptive statistics
| Standard deviation | 1092.19591 |
|---|---|
| Coef of variation | 1.192530474 |
| Kurtosis | 16.81983238 |
| Mean | 915.8641509 |
| MAD | 641.1677892 |
| Skewness | 3.67572609 |
| Sum | 242704 |
| Variance | 1192891.906 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 246 | 2 | 0.8% | |
| 582 | 2 | 0.8% | |
| 1044 | 2 | 0.8% | |
| 410 | 2 | 0.8% | |
| 355 | 2 | 0.8% | |
| 1484 | 2 | 0.8% | |
| 1160 | 2 | 0.8% | |
| 1212 | 2 | 0.8% | |
| 340 | 2 | 0.8% | |
| 243 | 2 | 0.8% | |
| Other values (231) | 245 | 92.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 83 | 1 | 0.4% | |
| 96 | 1 | 0.4% | |
| 120 | 1 | 0.4% | |
| 130 | 1 | 0.4% | |
| 136 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7961 | 1 | 0.4% | |
| 7803 | 1 | 0.4% | |
| 6262 | 1 | 0.4% | |
| 6103 | 1 | 0.4% | |
| 5340 | 1 | 0.4% |
qt_admitidos_12meses
Numeric
| Distinct count | 73 |
|---|---|
| Unique (%) | 27.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 28.06415094 |
|---|---|
| Minimum | 0 |
| Maximum | 782 |
| Zeros (%) | 61.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 27 |
| 95-th percentile | 132.2 |
| Maximum | 782 |
| Range | 782 |
| Interquartile range | 27 |
Descriptive statistics
| Standard deviation | 73.04087454 |
|---|---|
| Coef of variation | 2.602639741 |
| Kurtosis | 48.79607181 |
| Mean | 28.06415094 |
| MAD | 38.54211463 |
| Skewness | 5.908751273 |
| Sum | 7437 |
| Variance | 5334.969354 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 162 | 61.1% | |
| 35 | 3 | 1.1% | |
| 8 | 3 | 1.1% | |
| 1 | 3 | 1.1% | |
| 18 | 3 | 1.1% | |
| 87 | 3 | 1.1% | |
| 13 | 3 | 1.1% | |
| 12 | 3 | 1.1% | |
| 74 | 2 | 0.8% | |
| 14 | 2 | 0.8% | |
| Other values (63) | 78 | 29.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 162 | 61.1% | |
| 1 | 3 | 1.1% | |
| 2 | 2 | 0.8% | |
| 4 | 1 | 0.4% | |
| 6 | 2 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 782 | 1 | 0.4% | |
| 465 | 1 | 0.4% | |
| 332 | 1 | 0.4% | |
| 259 | 1 | 0.4% | |
| 256 | 1 | 0.4% |
qt_alteracao_socio_180d
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
qt_alteracao_socio_365d
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
qt_alteracao_socio_90d
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
qt_alteracao_socio_total
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
qt_art
Numeric
| Distinct count | 39 |
|---|---|
| Unique (%) | 14.7% |
| Missing (%) | 50.9% |
| Missing (n) | 135 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 21.51538462 |
|---|---|
| Minimum | 1 |
| Maximum | 912 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2.25 |
| Median | 6 |
| Q3 | 14 |
| 95-th percentile | 44 |
| Maximum | 912 |
| Range | 911 |
| Interquartile range | 11.75 |
Descriptive statistics
| Standard deviation | 87.8001814 |
|---|---|
| Coef of variation | 4.080809289 |
| Kurtosis | 86.51934653 |
| Mean | 21.51538462 |
| MAD | 25.25633136 |
| Skewness | 8.982447187 |
| Sum | 2797 |
| Variance | 7708.871855 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 20 | 7.5% | |
| 3 | 13 | 4.9% | |
| 2 | 13 | 4.9% | |
| 6 | 10 | 3.8% | |
| 5 | 9 | 3.4% | |
| 13 | 6 | 2.3% | |
| 7 | 6 | 2.3% | |
| 4 | 5 | 1.9% | |
| 14 | 4 | 1.5% | |
| 12 | 3 | 1.1% | |
| Other values (28) | 41 | 15.5% | |
| (Missing) | 135 | 50.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 20 | 7.5% | |
| 2 | 13 | 4.9% | |
| 3 | 13 | 4.9% | |
| 4 | 5 | 1.9% | |
| 5 | 9 | 3.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 912 | 1 | 0.4% | |
| 426 | 1 | 0.4% | |
| 88 | 1 | 0.4% | |
| 51 | 2 | 0.8% | |
| 45 | 1 | 0.4% |
qt_coligadas
Numeric
| Distinct count | 21 |
|---|---|
| Unique (%) | 7.9% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.973684211 |
|---|---|
| Minimum | 1 |
| Maximum | 57 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 6 |
| 95-th percentile | 36.5 |
| Maximum | 57 |
| Range | 56 |
| Interquartile range | 5 |
Descriptive statistics
| Standard deviation | 11.02962518 |
|---|---|
| Coef of variation | 1.581606629 |
| Kurtosis | 7.083269653 |
| Mean | 6.973684211 |
| MAD | 7.274930748 |
| Skewness | 2.633455034 |
| Sum | 530 |
| Variance | 121.6526316 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 27 | 10.2% | |
| 2 | 14 | 5.3% | |
| 3 | 7 | 2.6% | |
| 6 | 7 | 2.6% | |
| 4 | 3 | 1.1% | |
| 15 | 2 | 0.8% | |
| 8 | 2 | 0.8% | |
| 17 | 2 | 0.8% | |
| 9 | 1 | 0.4% | |
| 36 | 1 | 0.4% | |
| Other values (10) | 10 | 3.8% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 27 | 10.2% | |
| 2 | 14 | 5.3% | |
| 3 | 7 | 2.6% | |
| 4 | 3 | 1.1% | |
| 5 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 57 | 1 | 0.4% | |
| 40 | 1 | 0.4% | |
| 39 | 1 | 0.4% | |
| 38 | 1 | 0.4% | |
| 36 | 1 | 0.4% |
qt_coligados
Highly correlated
This variable is highly correlated with qt_coligadas and should be ignored for analysis
| Correlation | 1 |
|---|
qt_coligados_agropecuaria
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | 1.9% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| 0 | |
|---|---|
| 1 | 3 |
| 2 | 2 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 70 | 26.4% | |
| 1 | 3 | 1.1% | |
| 2 | 2 | 0.8% | |
| 4 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
qt_coligados_atividade_alto
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| 0 | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 76 | 28.7% | |
| (Missing) | 189 | 71.3% |
qt_coligados_atividade_baixo
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| 0 | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 76 | 28.7% | |
| (Missing) | 189 | 71.3% |
qt_coligados_atividade_inativo
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| 0 | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 76 | 28.7% | |
| (Missing) | 189 | 71.3% |
qt_coligados_atividade_medio
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| 0 | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 76 | 28.7% | |
| (Missing) | 189 | 71.3% |
qt_coligados_atividade_mt_baixo
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| 0 | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 76 | 28.7% | |
| (Missing) | 189 | 71.3% |
qt_coligados_ativo
Highly correlated
This variable is highly correlated with qt_coligados and should be ignored for analysis
| Correlation | 0.9997516702 |
|---|
qt_coligados_baixada
Highly correlated
This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis
| Correlation | 0.9718460044 |
|---|
qt_coligados_ccivil
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | 1.9% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| 0 | |
|---|---|
| 1 | 5 |
| 2 | 2 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 68 | 25.7% | |
| 1 | 5 | 1.9% | |
| 2 | 2 | 0.8% | |
| 3 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
qt_coligados_centro
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.3157894737 |
|---|---|
| Minimum | 0 |
| Maximum | 8 |
| Zeros (%) | 25.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.298311995 |
|---|---|
| Coef of variation | 4.111321316 |
| Kurtosis | 25.69387946 |
| Mean | 0.3157894737 |
| MAD | 0.5650969529 |
| Skewness | 5.017307957 |
| Sum | 24 |
| Variance | 1.685614035 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 68 | 25.7% | |
| 1 | 5 | 1.9% | |
| 8 | 1 | 0.4% | |
| 4 | 1 | 0.4% | |
| 7 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 68 | 25.7% | |
| 1 | 5 | 1.9% | |
| 4 | 1 | 0.4% | |
| 7 | 1 | 0.4% | |
| 8 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8 | 1 | 0.4% | |
| 7 | 1 | 0.4% | |
| 4 | 1 | 0.4% | |
| 1 | 5 | 1.9% | |
| 0 | 68 | 25.7% |
qt_coligados_comercio
Numeric
| Distinct count | 9 |
|---|---|
| Unique (%) | 3.4% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.092105263 |
|---|---|
| Minimum | 0 |
| Maximum | 26 |
| Zeros (%) | 17.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 26 |
| Range | 26 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 3.154584522 |
|---|---|
| Coef of variation | 2.888535225 |
| Kurtosis | 53.16937363 |
| Mean | 1.092105263 |
| MAD | 1.355955679 |
| Skewness | 6.822610724 |
| Sum | 83 |
| Variance | 9.951403509 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 46 | 17.4% | |
| 1 | 14 | 5.3% | |
| 2 | 9 | 3.4% | |
| 4 | 2 | 0.8% | |
| 3 | 2 | 0.8% | |
| 6 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| 26 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 46 | 17.4% | |
| 1 | 14 | 5.3% | |
| 2 | 9 | 3.4% | |
| 3 | 2 | 0.8% | |
| 4 | 2 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 26 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| 4 | 2 | 0.8% | |
| 3 | 2 | 0.8% |
qt_coligados_epp
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| 0 | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 76 | 28.7% | |
| (Missing) | 189 | 71.3% |
qt_coligados_exterior
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| 0 | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 76 | 28.7% | |
| (Missing) | 189 | 71.3% |
qt_coligados_inapta
Highly correlated
This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis
| Correlation | 0.9718460044 |
|---|
qt_coligados_industria
Numeric
| Distinct count | 8 |
|---|---|
| Unique (%) | 3.0% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.4473684211 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros (%) | 23.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 2.25 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.491261094 |
|---|---|
| Coef of variation | 3.33340715 |
| Kurtosis | 25.37777825 |
| Mean | 0.4473684211 |
| MAD | 0.7416897507 |
| Skewness | 4.762327507 |
| Sum | 34 |
| Variance | 2.223859649 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 63 | 23.8% | |
| 1 | 8 | 3.0% | |
| 10 | 1 | 0.4% | |
| 3 | 1 | 0.4% | |
| 2 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 63 | 23.8% | |
| 1 | 8 | 3.0% | |
| 2 | 1 | 0.4% | |
| 3 | 1 | 0.4% | |
| 5 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| 3 | 1 | 0.4% | |
| 2 | 1 | 0.4% |
qt_coligados_ltda
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.2631578947 |
|---|---|
| Minimum | 0 |
| Maximum | 8 |
| Zeros (%) | 26.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.170395045 |
|---|---|
| Coef of variation | 4.447501171 |
| Kurtosis | 32.87682671 |
| Mean | 0.2631578947 |
| MAD | 0.4778393352 |
| Skewness | 5.61595368 |
| Sum | 20 |
| Variance | 1.369824561 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 69 | 26.0% | |
| 1 | 4 | 1.5% | |
| 2 | 1 | 0.4% | |
| 8 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 69 | 26.0% | |
| 1 | 4 | 1.5% | |
| 2 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 8 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 2 | 1 | 0.4% | |
| 1 | 4 | 1.5% | |
| 0 | 69 | 26.0% |
qt_coligados_matriz
Highly correlated
This variable is highly correlated with qt_coligados_ativo and should be ignored for analysis
| Correlation | 0.9996971343 |
|---|
qt_coligados_me
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| 0 | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 76 | 28.7% | |
| (Missing) | 189 | 71.3% |
qt_coligados_mei
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| 0 | |
|---|---|
| 1 | 1 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 75 | 28.3% | |
| 1 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
qt_coligados_nordeste
Numeric
| Distinct count | 14 |
|---|---|
| Unique (%) | 5.3% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.618421053 |
|---|---|
| Minimum | 0 |
| Maximum | 36 |
| Zeros (%) | 11.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 2.25 |
| 95-th percentile | 9.75 |
| Maximum | 36 |
| Range | 36 |
| Interquartile range | 2.25 |
Descriptive statistics
| Standard deviation | 5.53767004 |
|---|---|
| Coef of variation | 2.114889061 |
| Kurtosis | 20.6502858 |
| Mean | 2.618421053 |
| MAD | 3.006578947 |
| Skewness | 4.20720687 |
| Sum | 199 |
| Variance | 30.66578947 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 31 | 11.7% | |
| 1 | 17 | 6.4% | |
| 2 | 9 | 3.4% | |
| 6 | 4 | 1.5% | |
| 3 | 4 | 1.5% | |
| 4 | 4 | 1.5% | |
| 36 | 1 | 0.4% | |
| 25 | 1 | 0.4% | |
| 12 | 1 | 0.4% | |
| 5 | 1 | 0.4% | |
| Other values (3) | 3 | 1.1% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 31 | 11.7% | |
| 1 | 17 | 6.4% | |
| 2 | 9 | 3.4% | |
| 3 | 4 | 1.5% | |
| 4 | 4 | 1.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 36 | 1 | 0.4% | |
| 25 | 1 | 0.4% | |
| 17 | 1 | 0.4% | |
| 12 | 1 | 0.4% | |
| 9 | 1 | 0.4% |
qt_coligados_norte
Numeric
| Distinct count | 14 |
|---|---|
| Unique (%) | 5.3% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.881578947 |
|---|---|
| Minimum | 0 |
| Maximum | 52 |
| Zeros (%) | 14.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 2 |
| 95-th percentile | 11.75 |
| Maximum | 52 |
| Range | 52 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 7.575340882 |
|---|---|
| Coef of variation | 2.62888542 |
| Kurtosis | 26.25778584 |
| Mean | 2.881578947 |
| MAD | 3.789819945 |
| Skewness | 4.775758542 |
| Sum | 219 |
| Variance | 57.38578947 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 39 | 14.7% | |
| 1 | 14 | 5.3% | |
| 2 | 6 | 2.3% | |
| 5 | 3 | 1.1% | |
| 3 | 3 | 1.1% | |
| 4 | 2 | 0.8% | |
| 9 | 2 | 0.8% | |
| 6 | 2 | 0.8% | |
| 22 | 1 | 0.4% | |
| 11 | 1 | 0.4% | |
| Other values (3) | 3 | 1.1% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 39 | 14.7% | |
| 1 | 14 | 5.3% | |
| 2 | 6 | 2.3% | |
| 3 | 3 | 1.1% | |
| 4 | 2 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 52 | 1 | 0.4% | |
| 32 | 1 | 0.4% | |
| 22 | 1 | 0.4% | |
| 14 | 1 | 0.4% | |
| 11 | 1 | 0.4% |
qt_coligados_nula
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| 0 | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 76 | 28.7% | |
| (Missing) | 189 | 71.3% |
qt_coligados_sa
Numeric
| Distinct count | 7 |
|---|---|
| Unique (%) | 2.6% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.5394736842 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros (%) | 24.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 4 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.700515918 |
|---|---|
| Coef of variation | 3.152175847 |
| Kurtosis | 16.01041505 |
| Mean | 0.5394736842 |
| MAD | 0.9085872576 |
| Skewness | 3.882045201 |
| Sum | 41 |
| Variance | 2.891754386 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 64 | 24.2% | |
| 1 | 6 | 2.3% | |
| 4 | 3 | 1.1% | |
| 10 | 1 | 0.4% | |
| 7 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 64 | 24.2% | |
| 1 | 6 | 2.3% | |
| 4 | 3 | 1.1% | |
| 6 | 1 | 0.4% | |
| 7 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 1 | 0.4% | |
| 7 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 4 | 3 | 1.1% | |
| 1 | 6 | 2.3% |
qt_coligados_serviço
Highly correlated
This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis
| Correlation | 0.9288399907 |
|---|
qt_coligados_sudeste
Numeric
| Distinct count | 9 |
|---|---|
| Unique (%) | 3.4% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.013157895 |
|---|---|
| Minimum | 0 |
| Maximum | 28 |
| Zeros (%) | 24.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 3.75 |
| Maximum | 28 |
| Range | 28 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 4.067737851 |
|---|---|
| Coef of variation | 4.014910087 |
| Kurtosis | 31.87862308 |
| Mean | 1.013157895 |
| MAD | 1.733379501 |
| Skewness | 5.47611395 |
| Sum | 77 |
| Variance | 16.54649123 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 65 | 24.5% | |
| 2 | 4 | 1.5% | |
| 3 | 2 | 0.8% | |
| 1 | 1 | 0.4% | |
| 8 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 28 | 1 | 0.4% | |
| 20 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 65 | 24.5% | |
| 1 | 1 | 0.4% | |
| 2 | 4 | 1.5% | |
| 3 | 2 | 0.8% | |
| 6 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 28 | 1 | 0.4% | |
| 20 | 1 | 0.4% | |
| 8 | 1 | 0.4% | |
| 6 | 1 | 0.4% | |
| 3 | 2 | 0.8% |
qt_coligados_sul
Highly correlated
This variable is highly correlated with qt_coligados_baixada and should be ignored for analysis
| Correlation | 0.9612903226 |
|---|
qt_coligados_suspensa
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| 0 | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 76 | 28.7% | |
| (Missing) | 189 | 71.3% |
qt_desligados
Highly correlated
This variable is highly correlated with qt_admitidos and should be ignored for analysis
| Correlation | 0.905610227 |
|---|
qt_desligados_12meses
Numeric
| Distinct count | 73 |
|---|---|
| Unique (%) | 27.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 23.92075472 |
|---|---|
| Minimum | 0 |
| Maximum | 394 |
| Zeros (%) | 60.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 21 |
| 95-th percentile | 125.6 |
| Maximum | 394 |
| Range | 394 |
| Interquartile range | 21 |
Descriptive statistics
| Standard deviation | 59.92998869 |
|---|---|
| Coef of variation | 2.505355262 |
| Kurtosis | 18.14991854 |
| Mean | 23.92075472 |
| MAD | 32.95723745 |
| Skewness | 4.020251455 |
| Sum | 6339 |
| Variance | 3591.603545 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 159 | 60.0% | |
| 27 | 6 | 2.3% | |
| 9 | 5 | 1.9% | |
| 8 | 4 | 1.5% | |
| 22 | 4 | 1.5% | |
| 29 | 3 | 1.1% | |
| 7 | 3 | 1.1% | |
| 1 | 3 | 1.1% | |
| 11 | 3 | 1.1% | |
| 5 | 3 | 1.1% | |
| Other values (63) | 72 | 27.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 159 | 60.0% | |
| 1 | 3 | 1.1% | |
| 2 | 1 | 0.4% | |
| 3 | 2 | 0.8% | |
| 4 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 394 | 1 | 0.4% | |
| 379 | 1 | 0.4% | |
| 366 | 1 | 0.4% | |
| 345 | 1 | 0.4% | |
| 277 | 1 | 0.4% |
qt_ex_funcionarios
Highly correlated
This variable is highly correlated with qt_desligados and should be ignored for analysis
| Correlation | 0.9999991015 |
|---|
qt_filiais
Numeric
| Distinct count | 21 |
|---|---|
| Unique (%) | 7.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.554716981 |
|---|---|
| Minimum | 0 |
| Maximum | 172 |
| Zeros (%) | 58.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 9.8 |
| Maximum | 172 |
| Range | 172 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 12.01001107 |
|---|---|
| Coef of variation | 4.701112162 |
| Kurtosis | 153.0330249 |
| Mean | 2.554716981 |
| MAD | 3.681594874 |
| Skewness | 11.40867694 |
| Sum | 677 |
| Variance | 144.2403659 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 155 | 58.5% | |
| 1 | 53 | 20.0% | |
| 2 | 17 | 6.4% | |
| 3 | 10 | 3.8% | |
| 5 | 4 | 1.5% | |
| 7 | 3 | 1.1% | |
| 4 | 3 | 1.1% | |
| 10 | 3 | 1.1% | |
| 12 | 2 | 0.8% | |
| 9 | 2 | 0.8% | |
| Other values (11) | 13 | 4.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 155 | 58.5% | |
| 1 | 53 | 20.0% | |
| 2 | 17 | 6.4% | |
| 3 | 10 | 3.8% | |
| 4 | 3 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 172 | 1 | 0.4% | |
| 51 | 1 | 0.4% | |
| 49 | 1 | 0.4% | |
| 42 | 1 | 0.4% | |
| 33 | 1 | 0.4% |
qt_funcionarios
Numeric
| Distinct count | 231 |
|---|---|
| Unique (%) | 87.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 468.6 |
|---|---|
| Minimum | 68 |
| Maximum | 3919 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 68 |
|---|---|
| 5-th percentile | 116 |
| Q1 | 188 |
| Median | 313 |
| Q3 | 539 |
| 95-th percentile | 1321.2 |
| Maximum | 3919 |
| Range | 3851 |
| Interquartile range | 351 |
Descriptive statistics
| Standard deviation | 494.5689568 |
|---|---|
| Coef of variation | 1.055418175 |
| Kurtosis | 16.01577453 |
| Mean | 468.6 |
| MAD | 310.0649057 |
| Skewness | 3.441655417 |
| Sum | 124179 |
| Variance | 244598.453 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 349 | 2 | 0.8% | |
| 353 | 2 | 0.8% | |
| 378 | 2 | 0.8% | |
| 677 | 2 | 0.8% | |
| 219 | 2 | 0.8% | |
| 188 | 2 | 0.8% | |
| 186 | 2 | 0.8% | |
| 199 | 2 | 0.8% | |
| 317 | 2 | 0.8% | |
| 212 | 2 | 0.8% | |
| Other values (221) | 245 | 92.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 68 | 1 | 0.4% | |
| 76 | 1 | 0.4% | |
| 82 | 1 | 0.4% | |
| 83 | 1 | 0.4% | |
| 85 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3919 | 1 | 0.4% | |
| 3172 | 1 | 0.4% | |
| 3104 | 1 | 0.4% | |
| 2669 | 1 | 0.4% | |
| 1936 | 1 | 0.4% |
qt_funcionarios_12meses
Highly correlated
This variable is highly correlated with qt_funcionarios and should be ignored for analysis
| Correlation | 0.9948729203 |
|---|
qt_funcionarios_24meses
Highly correlated
This variable is highly correlated with qt_funcionarios_12meses and should be ignored for analysis
| Correlation | 0.968894117 |
|---|
qt_funcionarios_coligados
Numeric
| Distinct count | 53 |
|---|---|
| Unique (%) | 20.0% |
| Missing (%) | 76.2% |
| Missing (n) | 202 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 551.031746 |
|---|---|
| Minimum | 0 |
| Maximum | 4770 |
| Zeros (%) | 1.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 10.5 |
| Median | 112 |
| Q3 | 510.5 |
| 95-th percentile | 3090.1 |
| Maximum | 4770 |
| Range | 4770 |
| Interquartile range | 500 |
Descriptive statistics
| Standard deviation | 1079.387595 |
|---|---|
| Coef of variation | 1.958848292 |
| Kurtosis | 7.119124121 |
| Mean | 551.031746 |
| MAD | 685.382716 |
| Skewness | 2.731363438 |
| Sum | 34715 |
| Variance | 1165077.58 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 5 | 1.9% | |
| 4 | 3 | 1.1% | |
| 23 | 2 | 0.8% | |
| 3 | 2 | 0.8% | |
| 1 | 2 | 0.8% | |
| 11 | 2 | 0.8% | |
| 617 | 2 | 0.8% | |
| 54 | 1 | 0.4% | |
| 152 | 1 | 0.4% | |
| 312 | 1 | 0.4% | |
| Other values (42) | 42 | 15.8% | |
| (Missing) | 202 | 76.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 5 | 1.9% | |
| 1 | 2 | 0.8% | |
| 2 | 1 | 0.4% | |
| 3 | 2 | 0.8% | |
| 4 | 3 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4770 | 1 | 0.4% | |
| 4463 | 1 | 0.4% | |
| 4124 | 1 | 0.4% | |
| 3183 | 1 | 0.4% | |
| 2254 | 1 | 0.4% |
qt_funcionarios_coligados_gp
Highly correlated
This variable is highly correlated with qt_coligados_inapta and should be ignored for analysis
| Correlation | 0.9231363224 |
|---|
qt_funcionarios_grupo
Highly correlated
This variable is highly correlated with qt_funcionarios_24meses and should be ignored for analysis
| Correlation | 0.9502971077 |
|---|
qt_ramos_coligados
Highly correlated
This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis
| Correlation | 0.9346159264 |
|---|
qt_regioes_coligados
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.407894737 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.9118133081 |
|---|---|
| Coef of variation | 0.6476430973 |
| Kurtosis | 4.718362297 |
| Mean | 1.407894737 |
| MAD | 0.6440443213 |
| Skewness | 2.339935018 |
| Sum | 107 |
| Variance | 0.8314035088 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 60 | 22.6% | |
| 2 | 7 | 2.6% | |
| 3 | 4 | 1.5% | |
| 4 | 4 | 1.5% | |
| 5 | 1 | 0.4% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 60 | 22.6% | |
| 2 | 7 | 2.6% | |
| 3 | 4 | 1.5% | |
| 4 | 4 | 1.5% | |
| 5 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5 | 1 | 0.4% | |
| 4 | 4 | 1.5% | |
| 3 | 4 | 1.5% | |
| 2 | 7 | 2.6% | |
| 1 | 60 | 22.6% |
qt_socios
Highly correlated
This variable is highly correlated with qt_coligados_mei and should be ignored for analysis
| Correlation | 0.9899466719 |
|---|
qt_socios_coligados
Numeric
| Distinct count | 23 |
|---|---|
| Unique (%) | 8.7% |
| Missing (%) | 71.3% |
| Missing (n) | 189 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 12.76315789 |
|---|---|
| Minimum | 1 |
| Maximum | 138 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 3 |
| Q3 | 12 |
| 95-th percentile | 58.5 |
| Maximum | 138 |
| Range | 137 |
| Interquartile range | 11 |
Descriptive statistics
| Standard deviation | 26.83125959 |
|---|---|
| Coef of variation | 2.102243019 |
| Kurtosis | 12.26288439 |
| Mean | 12.76315789 |
| MAD | 15.08587258 |
| Skewness | 3.488701101 |
| Sum | 970 |
| Variance | 719.9164912 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 1 | 24 | 9.1% | |
| 2 | 13 | 4.9% | |
| 4 | 5 | 1.9% | |
| 3 | 4 | 1.5% | |
| 5 | 4 | 1.5% | |
| 14 | 3 | 1.1% | |
| 6 | 3 | 1.1% | |
| 24 | 2 | 0.8% | |
| 28 | 2 | 0.8% | |
| 12 | 2 | 0.8% | |
| Other values (12) | 14 | 5.3% | |
| (Missing) | 189 | 71.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 24 | 9.1% | |
| 2 | 13 | 4.9% | |
| 3 | 4 | 1.5% | |
| 4 | 5 | 1.9% | |
| 5 | 4 | 1.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 138 | 1 | 0.4% | |
| 128 | 1 | 0.4% | |
| 107 | 1 | 0.4% | |
| 96 | 1 | 0.4% | |
| 46 | 1 | 0.4% |
qt_socios_feminino
Highly correlated
This variable is highly correlated with qt_socios and should be ignored for analysis
| Correlation | 0.9936468189 |
|---|
qt_socios_masculino
Highly correlated
This variable is highly correlated with qt_socios_feminino and should be ignored for analysis
| Correlation | 0.9916264524 |
|---|
qt_socios_pep
Highly correlated
This variable is highly correlated with qt_socios_masculino and should be ignored for analysis
| Correlation | 0.9954550751 |
|---|
qt_socios_pf
Highly correlated
This variable is highly correlated with qt_socios_pep and should be ignored for analysis
| Correlation | 0.9960939342 |
|---|
qt_socios_pj
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 63.0% |
| Missing (n) | 167 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.2551020408 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros (%) | 31.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.7365456361 |
|---|---|
| Coef of variation | 2.887258893 |
| Kurtosis | 19.40726857 |
| Mean | 0.2551020408 |
| MAD | 0.4321116202 |
| Skewness | 3.979704856 |
| Sum | 25 |
| Variance | 0.542499474 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 83 | 31.3% | |
| 1 | 9 | 3.4% | |
| 2 | 4 | 1.5% | |
| 5 | 1 | 0.4% | |
| 3 | 1 | 0.4% | |
| (Missing) | 167 | 63.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 83 | 31.3% | |
| 1 | 9 | 3.4% | |
| 2 | 4 | 1.5% | |
| 3 | 1 | 0.4% | |
| 5 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5 | 1 | 0.4% | |
| 3 | 1 | 0.4% | |
| 2 | 4 | 1.5% | |
| 1 | 9 | 3.4% | |
| 0 | 83 | 31.3% |
qt_socios_pj_ativos
Highly correlated
This variable is highly correlated with qt_socios_pj and should be ignored for analysis
| Correlation | 1 |
|---|
qt_socios_pj_baixados
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 94.3% |
| Missing (n) | 250 |
| 0 | 15 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 15 | 5.7% | |
| (Missing) | 250 | 94.3% |
qt_socios_pj_inaptos
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 94.3% |
| Missing (n) | 250 |
| 0 | 15 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 15 | 5.7% | |
| (Missing) | 250 | 94.3% |
qt_socios_pj_nulos
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 94.3% |
| Missing (n) | 250 |
| 0 | 15 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 15 | 5.7% | |
| (Missing) | 250 | 94.3% |
qt_socios_pj_suspensos
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 94.3% |
| Missing (n) | 250 |
| 0 | 15 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 15 | 5.7% | |
| (Missing) | 250 | 94.3% |
qt_socios_st_regular
Highly correlated
This variable is highly correlated with qt_socios_pf and should be ignored for analysis
| Correlation | 0.9983592345 |
|---|
qt_socios_st_suspensa
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
qt_ufs_coligados
Highly correlated
This variable is highly correlated with qt_regioes_coligados and should be ignored for analysis
| Correlation | 0.9026409791 |
|---|
setor
Constant
This variable is constant and should be ignored for analysis
| Constant value | SERVIÇO |
|---|
sg_uf
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| MA | |
|---|---|
| PI | |
| RN | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| MA | 74 | 27.9% | |
| PI | 52 | 19.6% | |
| RN | 51 | 19.2% | |
| AM | 43 | 16.2% | |
| AC | 23 | 8.7% | |
| RO | 22 | 8.3% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
sg_uf_matriz
Recoded
This variable is a recoding of sg_uf and should be ignored for analysis
sum_faturamento_estimado_coligadas
Highly correlated
This variable is highly correlated with media_faturamento_est_coligados_gp and should be ignored for analysis
| Correlation | 0.9016602831 |
|---|
total
Highly correlated
This variable is highly correlated with qt_funcionarios_grupo and should be ignored for analysis
| Correlation | 0.9743124436 |
|---|
total_filiais_coligados
Highly correlated
This variable is highly correlated with qt_funcionarios_coligados_gp and should be ignored for analysis
| Correlation | 0.9354643228 |
|---|
tx_crescimento_12meses
Numeric
| Distinct count | 104 |
|---|---|
| Unique (%) | 39.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 51.83115614 |
|---|---|
| Minimum | -29.63265306 |
| Maximum | 12700 |
| Zeros (%) | 60.8% |
Quantile statistics
| Minimum | -29.63265306 |
|---|---|
| 5-th percentile | -6.509605013 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 29.53423981 |
| Maximum | 12700 |
| Range | 12729.63265 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 780.1739957 |
|---|---|
| Coef of variation | 15.05222059 |
| Kurtosis | 264.6427775 |
| Mean | 51.83115614 |
| MAD | 97.85147727 |
| Skewness | 16.26255534 |
| Sum | 13735.25638 |
| Variance | 608671.4636 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 161 | 60.8% | |
| 6.382978723 | 2 | 0.8% | |
| 40.6779661 | 1 | 0.4% | |
| 13.71115174 | 1 | 0.4% | |
| 75.6097561 | 1 | 0.4% | |
| 27.1393643 | 1 | 0.4% | |
| 40.99099099 | 1 | 0.4% | |
| -9.80861244 | 1 | 0.4% | |
| -1.45631068 | 1 | 0.4% | |
| -29.63265306 | 1 | 0.4% | |
| Other values (94) | 94 | 35.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -29.63265306 | 1 | 0.4% | |
| -25.87917042 | 1 | 0.4% | |
| -14.604811 | 1 | 0.4% | |
| -14.5175064 | 1 | 0.4% | |
| -13.58024691 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 12700 | 1 | 0.4% | |
| 246.1538462 | 1 | 0.4% | |
| 100 | 1 | 0.4% | |
| 77.64705882 | 1 | 0.4% | |
| 75.6097561 | 1 | 0.4% |
tx_crescimento_24meses
Highly correlated
This variable is highly correlated with tx_crescimento_12meses and should be ignored for analysis
| Correlation | 0.9959598268 |
|---|
tx_rotatividade
Numeric
| Distinct count | 106 |
|---|---|
| Unique (%) | 40.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.566274968 |
|---|---|
| Minimum | 0 |
| Maximum | 101.0869565 |
| Zeros (%) | 60.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 11.39369278 |
| 95-th percentile | 28.69354055 |
| Maximum | 101.0869565 |
| Range | 101.0869565 |
| Interquartile range | 11.39369278 |
Descriptive statistics
| Standard deviation | 11.82783766 |
|---|---|
| Coef of variation | 1.801300999 |
| Kurtosis | 16.07742863 |
| Mean | 6.566274968 |
| MAD | 8.611309487 |
| Skewness | 3.063189929 |
| Sum | 1740.062866 |
| Variance | 139.8977438 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 160 | 60.4% | |
| 9.03696942 | 1 | 0.4% | |
| 36.06557377 | 1 | 0.4% | |
| 40.25974026 | 1 | 0.4% | |
| 2.575107296 | 1 | 0.4% | |
| 4.532577904 | 1 | 0.4% | |
| 18.73605948 | 1 | 0.4% | |
| 34.30232558 | 1 | 0.4% | |
| 4.888888889 | 1 | 0.4% | |
| 9.900990099 | 1 | 0.4% | |
| Other values (96) | 96 | 36.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 160 | 60.4% | |
| 0.1338688086 | 1 | 0.4% | |
| 0.1431639227 | 1 | 0.4% | |
| 0.5611672278 | 1 | 0.4% | |
| 0.8298755187 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 101.0869565 | 1 | 0.4% | |
| 55.35248042 | 1 | 0.4% | |
| 42.66666667 | 1 | 0.4% | |
| 40.25974026 | 1 | 0.4% | |
| 39.18367347 | 1 | 0.4% |
Unnamed_0_x
Numeric
| Distinct count | 265 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 132 |
|---|---|
| Minimum | 0 |
| Maximum | 264 |
| Zeros (%) | 0.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 13.2 |
| Q1 | 66 |
| Median | 132 |
| Q3 | 198 |
| 95-th percentile | 250.8 |
| Maximum | 264 |
| Range | 264 |
| Interquartile range | 132 |
Descriptive statistics
| Standard deviation | 76.64311232 |
|---|---|
| Coef of variation | 0.5806296388 |
| Kurtosis | -1.2 |
| Mean | 132 |
| MAD | 66.2490566 |
| Skewness | 0 |
| Sum | 34980 |
| Variance | 5874.166667 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 264 | 1 | 0.4% | |
| 82 | 1 | 0.4% | |
| 96 | 1 | 0.4% | |
| 95 | 1 | 0.4% | |
| 94 | 1 | 0.4% | |
| 93 | 1 | 0.4% | |
| 92 | 1 | 0.4% | |
| 91 | 1 | 0.4% | |
| 90 | 1 | 0.4% | |
| 89 | 1 | 0.4% | |
| Other values (255) | 255 | 96.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.4% | |
| 1 | 1 | 0.4% | |
| 2 | 1 | 0.4% | |
| 3 | 1 | 0.4% | |
| 4 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 264 | 1 | 0.4% | |
| 263 | 1 | 0.4% | |
| 262 | 1 | 0.4% | |
| 261 | 1 | 0.4% | |
| 260 | 1 | 0.4% |
Unnamed_0_y
Highly correlated
This variable is highly correlated with Unnamed_0_x and should be ignored for analysis
| Correlation | 0.9988970638 |
|---|
vl_faturamento_estimado_aux
Numeric
| Distinct count | 248 |
|---|---|
| Unique (%) | 93.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 108007862.2 |
|---|---|
| Minimum | 20039724 |
| Maximum | 2011596800 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 20039724 |
|---|---|
| 5-th percentile | 22584614.4 |
| Q1 | 30600504 |
| Median | 51000840 |
| Q3 | 99786500 |
| 95-th percentile | 378652900 |
| Maximum | 2011596800 |
| Range | 1991557076 |
| Interquartile range | 69185996 |
Descriptive statistics
| Standard deviation | 192627638.9 |
|---|---|
| Coef of variation | 1.783459417 |
| Kurtosis | 45.08106971 |
| Mean | 108007862.2 |
| MAD | 94175330.34 |
| Skewness | 5.851507067 |
| Sum | 2.862208347e+10 |
| Variance | 3.710540726e+16 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 24624648 | 3 | 1.1% | |
| 24882228 | 2 | 0.8% | |
| 49661424 | 2 | 0.8% | |
| 45282564 | 2 | 0.8% | |
| 24418584 | 2 | 0.8% | |
| 23336748 | 2 | 0.8% | |
| 117404960 | 2 | 0.8% | |
| 23388264 | 2 | 0.8% | |
| 27818640 | 2 | 0.8% | |
| 27870156 | 2 | 0.8% | |
| Other values (238) | 244 | 92.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 20039724 | 1 | 0.4% | |
| 20245788 | 1 | 0.4% | |
| 20606400 | 2 | 0.8% | |
| 20709432 | 1 | 0.4% | |
| 20760948 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2011596800 | 1 | 0.4% | |
| 1375889300 | 1 | 0.4% | |
| 930378940 | 1 | 0.4% | |
| 914615040 | 1 | 0.4% | |
| 755585150 | 1 | 0.4% |
vl_faturamento_estimado_grupo_aux
Highly correlated
This variable is highly correlated with vl_faturamento_estimado_aux and should be ignored for analysis
| Correlation | 0.9811022766 |
|---|
vl_folha_coligados
Highly correlated
This variable is highly correlated with qt_funcionarios_coligados and should be ignored for analysis
| Correlation | 0.961120251 |
|---|
vl_folha_coligados_gp
Highly correlated
This variable is highly correlated with vl_folha_coligados and should be ignored for analysis
| Correlation | 0.9428868609 |
|---|
vl_frota
Highly correlated
This variable is highly correlated with qt_socios_pep and should be ignored for analysis
| Correlation | 0.9138805515 |
|---|
vl_idade_maxima_socios_pj
Numeric
| Distinct count | 16 |
|---|---|
| Unique (%) | 6.0% |
| Missing (%) | 94.3% |
| Missing (n) | 250 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 24.03741729 |
|---|---|
| Minimum | 0.7611225188 |
| Maximum | 52.28199863 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.7611225188 |
|---|---|
| 5-th percentile | 3.229568789 |
| Q1 | 9.338809035 |
| Median | 27.80013689 |
| Q3 | 35.41820671 |
| 95-th percentile | 47.39685147 |
| Maximum | 52.28199863 |
| Range | 51.52087611 |
| Interquartile range | 26.07939767 |
Descriptive statistics
| Standard deviation | 16.28980879 |
|---|---|
| Coef of variation | 0.6776854846 |
| Kurtosis | -1.234614151 |
| Mean | 24.03741729 |
| MAD | 14.08228763 |
| Skewness | 0.1416487434 |
| Sum | 360.5612594 |
| Variance | 265.3578703 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 27.80013689 | 1 | 0.4% | |
| 32.94182067 | 1 | 0.4% | |
| 7.882272416 | 1 | 0.4% | |
| 18.33812457 | 1 | 0.4% | |
| 52.28199863 | 1 | 0.4% | |
| 4.287474333 | 1 | 0.4% | |
| 10.79534565 | 1 | 0.4% | |
| 37.89459274 | 1 | 0.4% | |
| 14.28336756 | 1 | 0.4% | |
| 40.98288843 | 1 | 0.4% | |
| Other values (5) | 5 | 1.9% | |
| (Missing) | 250 | 94.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.7611225188 | 1 | 0.4% | |
| 4.287474333 | 1 | 0.4% | |
| 6.29705681 | 1 | 0.4% | |
| 7.882272416 | 1 | 0.4% | |
| 10.79534565 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 52.28199863 | 1 | 0.4% | |
| 45.30321697 | 1 | 0.4% | |
| 40.98288843 | 1 | 0.4% | |
| 37.89459274 | 1 | 0.4% | |
| 32.94182067 | 1 | 0.4% |
vl_idade_media_socios_pj
Numeric
| Distinct count | 16 |
|---|---|
| Unique (%) | 6.0% |
| Missing (%) | 94.3% |
| Missing (n) | 250 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 17.75692144 |
|---|---|
| Minimum | 0.7611225188 |
| Maximum | 40.98288843 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.7611225188 |
|---|---|
| 5-th percentile | 3.229568789 |
| Q1 | 9.338809035 |
| Median | 15.05087839 |
| Q3 | 27.46817248 |
| 95-th percentile | 35.354141 |
| Maximum | 40.98288843 |
| Range | 40.22176591 |
| Interquartile range | 18.12936345 |
Descriptive statistics
| Standard deviation | 11.97944205 |
|---|---|
| Coef of variation | 0.6746350763 |
| Kurtosis | -0.7206734384 |
| Mean | 17.75692144 |
| MAD | 9.726381626 |
| Skewness | 0.5442538678 |
| Sum | 266.3538216 |
| Variance | 143.5070318 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 32.94182067 | 1 | 0.4% | |
| 7.882272416 | 1 | 0.4% | |
| 18.33812457 | 1 | 0.4% | |
| 15.05087839 | 1 | 0.4% | |
| 32.29021218 | 1 | 0.4% | |
| 4.287474333 | 1 | 0.4% | |
| 15.93839836 | 1 | 0.4% | |
| 10.79534565 | 1 | 0.4% | |
| 14.28336756 | 1 | 0.4% | |
| 23.5742642 | 1 | 0.4% | |
| Other values (5) | 5 | 1.9% | |
| (Missing) | 250 | 94.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.7611225188 | 1 | 0.4% | |
| 4.287474333 | 1 | 0.4% | |
| 6.29705681 | 1 | 0.4% | |
| 7.882272416 | 1 | 0.4% | |
| 10.79534565 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 40.98288843 | 1 | 0.4% | |
| 32.94182067 | 1 | 0.4% | |
| 32.29021218 | 1 | 0.4% | |
| 31.36208077 | 1 | 0.4% | |
| 23.5742642 | 1 | 0.4% |
vl_idade_minima_socios_pj
Numeric
| Distinct count | 16 |
|---|---|
| Unique (%) | 6.0% |
| Missing (%) | 94.3% |
| Missing (n) | 250 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13.75952544 |
|---|---|
| Minimum | 0.6598220397 |
| Maximum | 40.98288843 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.6598220397 |
|---|---|
| 5-th percentile | 0.7307323751 |
| Q1 | 3.957563313 |
| Median | 10.79534565 |
| Q3 | 18.84325804 |
| 95-th percentile | 35.354141 |
| Maximum | 40.98288843 |
| Range | 40.32306639 |
| Interquartile range | 14.88569473 |
Descriptive statistics
| Standard deviation | 12.62551595 |
|---|---|
| Coef of variation | 0.9175836775 |
| Kurtosis | 0.03197410952 |
| Mean | 13.75952544 |
| MAD | 9.959936117 |
| Skewness | 1.005764265 |
| Sum | 206.3928816 |
| Variance | 159.4036531 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 32.94182067 | 1 | 0.4% | |
| 7.882272416 | 1 | 0.4% | |
| 12.29842574 | 1 | 0.4% | |
| 18.33812457 | 1 | 0.4% | |
| 4.287474333 | 1 | 0.4% | |
| 0.6598220397 | 1 | 0.4% | |
| 10.79534565 | 1 | 0.4% | |
| 14.28336756 | 1 | 0.4% | |
| 40.98288843 | 1 | 0.4% | |
| 31.36208077 | 1 | 0.4% | |
| Other values (5) | 5 | 1.9% | |
| (Missing) | 250 | 94.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.6598220397 | 1 | 0.4% | |
| 0.7611225188 | 1 | 0.4% | |
| 2.527036277 | 1 | 0.4% | |
| 3.627652293 | 1 | 0.4% | |
| 4.287474333 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 40.98288843 | 1 | 0.4% | |
| 32.94182067 | 1 | 0.4% | |
| 31.36208077 | 1 | 0.4% | |
| 19.34839151 | 1 | 0.4% | |
| 18.33812457 | 1 | 0.4% |
vl_potenc_cons_oleo_gas
Numeric
| Distinct count | 21 |
|---|---|
| Unique (%) | 7.9% |
| Missing (%) | 91.7% |
| Missing (n) | 243 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 101.9090909 |
|---|---|
| Minimum | 1 |
| Maximum | 430 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2.05 |
| Q1 | 21.25 |
| Median | 45 |
| Q3 | 163.5 |
| 95-th percentile | 368.45 |
| Maximum | 430 |
| Range | 429 |
| Interquartile range | 142.25 |
Descriptive statistics
| Standard deviation | 125.4428001 |
|---|---|
| Coef of variation | 1.230928458 |
| Kurtosis | 1.339303396 |
| Mean | 101.9090909 |
| MAD | 100.5123967 |
| Skewness | 1.485816228 |
| Sum | 2242 |
| Variance | 15735.8961 |
| Memory size | 14.1 KiB |
| Value | Count | Frequency (%) | |
| 32 | 2 | 0.8% | |
| 45 | 2 | 0.8% | |
| 22 | 1 | 0.4% | |
| 7 | 1 | 0.4% | |
| 216 | 1 | 0.4% | |
| 374 | 1 | 0.4% | |
| 226 | 1 | 0.4% | |
| 3 | 1 | 0.4% | |
| 138 | 1 | 0.4% | |
| 172 | 1 | 0.4% | |
| Other values (10) | 10 | 3.8% | |
| (Missing) | 243 | 91.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.4% | |
| 2 | 1 | 0.4% | |
| 3 | 1 | 0.4% | |
| 7 | 1 | 0.4% | |
| 8 | 1 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 430 | 1 | 0.4% | |
| 374 | 1 | 0.4% | |
| 263 | 1 | 0.4% | |
| 226 | 1 | 0.4% | |
| 216 | 1 | 0.4% |
vl_total_tancagem
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | 1.9% |
| Missing (%) | 96.2% |
| Missing (n) | 255 |
| 15 | 7 |
|---|---|
| 45 | 1 |
| 40 | 1 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 15 | 7 | 2.6% | |
| 45 | 1 | 0.4% | |
| 40 | 1 | 0.4% | |
| 30 | 1 | 0.4% | |
| (Missing) | 255 | 96.2% |
| Max length | 4 |
|---|---|
| Mean length | 3.037735849 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
vl_total_tancagem_grupo
Highly correlated
This variable is highly correlated with vl_idade_minima_socios_pj and should be ignored for analysis
| Correlation | 0.9444166274 |
|---|
vl_total_veiculos_antt
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
vl_total_veiculos_antt_grupo
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
vl_total_veiculos_leves
Highly correlated
This variable is highly correlated with qt_socios_pep and should be ignored for analysis
| Correlation | 0.9328182339 |
|---|
vl_total_veiculos_leves_grupo
Highly correlated
This variable is highly correlated with vl_total_veiculos_leves and should be ignored for analysis
| Correlation | 0.9972729314 |
|---|
vl_total_veiculos_pesados
Highly correlated
This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis
| Correlation | 0.9929030146 |
|---|
vl_total_veiculos_pesados_grupo
Highly correlated
This variable is highly correlated with vl_total_veiculos_pesados and should be ignored for analysis
| Correlation | 0.9978083954 |
|---|
First rows
| coligada_mais_antiga_ativa | coligada_mais_antiga_baixada | coligada_mais_nova_ativa | coligada_mais_nova_baixada | de_faixa_faturamento_estimado | de_faixa_faturamento_estimado_grupo | de_indicador_telefone | de_natureza_juridica | de_nivel_atividade | de_ramo | de_saude_rescencia | de_saude_tributaria | dt_situacao | empsetorcensitariofaixarendapopulacao | faturamento_est_coligados | faturamento_est_coligados_gp | fl_antt | fl_email | fl_epp | fl_ltda | fl_matriz | fl_me | fl_mei | fl_optante_simei | fl_optante_simples | fl_passivel_iss | fl_rm | fl_sa | fl_simples_irregular | fl_spa | fl_st_especial | fl_telefone | fl_veiculo | grau_instrucao_macro_analfabeto | grau_instrucao_macro_desconhecido | grau_instrucao_macro_escolaridade_fundamental | grau_instrucao_macro_escolaridade_media | grau_instrucao_macro_escolaridade_superior | id | idade_acima_de_58 | idade_ate_18 | idade_de_19_a_23 | idade_de_24_a_28 | idade_de_29_a_33 | idade_de_34_a_38 | idade_de_39_a_43 | idade_de_44_a_48 | idade_de_49_a_53 | idade_de_54_a_58 | idade_emp_cat | idade_empresa_anos | idade_maxima_coligadas | idade_maxima_socios | idade_media_coligadas | idade_media_coligadas_ativas | idade_media_coligadas_baixadas | idade_media_socios | idade_minima_coligadas | idade_minima_socios | max_faturamento_est_coligados | max_faturamento_est_coligados_gp | max_filiais_coligados | max_funcionarios_coligados_gp | max_meses_servicos | max_meses_servicos_all | max_vl_folha_coligados | max_vl_folha_coligados_gp | media_faturamento_est_coligados | media_faturamento_est_coligados_gp | media_filiais_coligados | media_funcionarios_coligados_gp | media_meses_servicos | media_meses_servicos_all | media_vl_folha_coligados | media_vl_folha_coligados_gp | meses_ultima_contratacaco | min_faturamento_est_coligados | min_faturamento_est_coligados_gp | min_filiais_coligados | min_funcionarios_coligados_gp | min_meses_servicos | min_meses_servicos_all | min_vl_folha_coligados | min_vl_folha_coligados_gp | natureza_juridica_macro | nm_divisao | nm_meso_regiao | nm_micro_regiao | nm_segmento | nu_meses_rescencia | percent_func_genero_fem | percent_func_genero_masc | qt_admitidos | qt_admitidos_12meses | qt_alteracao_socio_180d | qt_alteracao_socio_365d | qt_alteracao_socio_90d | qt_alteracao_socio_total | qt_art | qt_coligadas | qt_coligados | qt_coligados_agropecuaria | qt_coligados_atividade_alto | qt_coligados_atividade_baixo | qt_coligados_atividade_inativo | qt_coligados_atividade_medio | qt_coligados_atividade_mt_baixo | qt_coligados_ativo | qt_coligados_baixada | qt_coligados_ccivil | qt_coligados_centro | qt_coligados_comercio | qt_coligados_epp | qt_coligados_exterior | qt_coligados_inapta | qt_coligados_industria | qt_coligados_ltda | qt_coligados_matriz | qt_coligados_me | qt_coligados_mei | qt_coligados_nordeste | qt_coligados_norte | qt_coligados_nula | qt_coligados_sa | qt_coligados_serviço | qt_coligados_sudeste | qt_coligados_sul | qt_coligados_suspensa | qt_desligados | qt_desligados_12meses | qt_ex_funcionarios | qt_filiais | qt_funcionarios | qt_funcionarios_12meses | qt_funcionarios_24meses | qt_funcionarios_coligados | qt_funcionarios_coligados_gp | qt_funcionarios_grupo | qt_ramos_coligados | qt_regioes_coligados | qt_socios | qt_socios_coligados | qt_socios_feminino | qt_socios_masculino | qt_socios_pep | qt_socios_pf | qt_socios_pj | qt_socios_pj_ativos | qt_socios_pj_baixados | qt_socios_pj_inaptos | qt_socios_pj_nulos | qt_socios_pj_suspensos | qt_socios_st_regular | qt_socios_st_suspensa | qt_ufs_coligados | setor | sg_uf | sg_uf_matriz | sum_faturamento_estimado_coligadas | total | total_filiais_coligados | tx_crescimento_12meses | tx_crescimento_24meses | tx_rotatividade | Unnamed_0_x | Unnamed_0_y | vl_faturamento_estimado_aux | vl_faturamento_estimado_grupo_aux | vl_folha_coligados | vl_folha_coligados_gp | vl_frota | vl_idade_maxima_socios_pj | vl_idade_media_socios_pj | vl_idade_minima_socios_pj | vl_potenc_cons_oleo_gas | vl_total_tancagem | vl_total_tancagem_grupo | vl_total_veiculos_antt | vl_total_veiculos_antt_grupo | vl_total_veiculos_leves | vl_total_veiculos_leves_grupo | vl_total_veiculos_pesados | vl_total_veiculos_pesados_grupo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | NaN | NaN | NaN | NaN | DE R$ 100.000.000,01 A R$ 300.000.000,00 | DE R$ 100.000.000,01 A R$ 300.000.000,00 | NaN | MUNICIPIO | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | VERDE | 2005-11-03 | 644.27 | NaN | NaN | False | True | False | False | True | False | False | False | False | True | NAO | False | False | False | False | False | True | NaN | NaN | 117.0 | 106.0 | 522.0 | bb61c09449a1c1f8b78955d8b7a7f73599e78358993fe2... | 45.0 | NaN | NaN | 44.0 | 107.0 | 162.0 | 161.0 | 113.0 | 69.0 | 44.0 | > 20 | 21.813699 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 259.166667 | 259.166667 | NaN | NaN | NaN | NaN | NaN | NaN | 144.663535 | 133.286943 | NaN | NaN | 40.500000 | NaN | NaN | NaN | NaN | 40.500000 | -2.466667 | NaN | NaN | OUTROS | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | OESTE MARANHENSE | PINDARE | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 26.0 | 63.36 | 36.64 | 845.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 100.0 | 0.0 | 100.0 | 2 | 745.0 | 745.0 | 745.0 | NaN | NaN | 745.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | MA | MA | NaN | 745.0 | NaN | 0.000000 | 0.000000 | 0.000000 | 0 | 3116 | 141308380.0 | 144348380.0 | NaN | NaN | 275282.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 5.0 | 5.0 | 2.0 | 2.0 |
| 1 | NaN | NaN | NaN | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | SOCIEDADE SIMPLES LIMITADA | ALTA | SERVICOS DE EDUCACAO | ACIMA DE 1 ANO | VERDE | 2005-09-24 | 688.31 | NaN | NaN | False | False | False | False | True | False | False | False | False | True | NAO | False | False | False | False | True | True | NaN | NaN | 19.0 | 9.0 | 91.0 | 16843c9ffb920170477118933798510d8d5f00f5c56c12... | 2.0 | NaN | 1.0 | 10.0 | 27.0 | 30.0 | 20.0 | 15.0 | 11.0 | 3.0 | 15 a 20 | 16.389041 | NaN | 70.0 | NaN | NaN | NaN | 70.0 | NaN | 70.0 | NaN | NaN | NaN | NaN | 149.033333 | 149.033333 | NaN | NaN | NaN | NaN | NaN | NaN | 65.942017 | 42.166782 | NaN | NaN | 4.866667 | NaN | NaN | NaN | NaN | 4.866667 | 0.000000 | NaN | NaN | ENTIDADES EMPRESARIAIS | EDUCACAO | NORTE PIAUIENSE | BAIXO PARNAIBA PIAUIENSE | EDUCACAO | 23.0 | 47.90 | 52.10 | 291.0 | 21.0 | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 172.0 | 7.0 | 172.0 | 0 | 119.0 | 104.0 | 113.0 | NaN | NaN | 119.0 | NaN | NaN | 2.0 | NaN | 1.0 | NaN | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | SERVIÇO | PI | PI | NaN | 119.0 | NaN | 14.423077 | 5.309735 | 6.250000 | 1 | 3681 | 27818640.0 | 27818640.0 | NaN | NaN | 60101.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | 1.0 | 1.0 | 1.0 |
| 2 | NaN | NaN | NaN | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU D... | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | AZUL | 1998-07-28 | 1881.35 | NaN | NaN | False | True | False | False | True | False | False | False | False | True | SIM | False | False | False | False | True | False | NaN | NaN | 56.0 | 26.0 | 88.0 | 1b8d092daff12bed8b3c2ab93bf5df2921865a68aca185... | 73.0 | NaN | 1.0 | 7.0 | 10.0 | 11.0 | 12.0 | 9.0 | 14.0 | 33.0 | > 20 | 40.380822 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 557.866667 | 5014.966667 | NaN | NaN | NaN | NaN | NaN | NaN | 284.854706 | 216.077090 | NaN | NaN | 24.200000 | NaN | NaN | NaN | NaN | 24.200000 | 0.633333 | NaN | NaN | ADMINISTRACAO PUBLICA | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | CENTRO AMAZONENSE | MANAUS | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 23.0 | 56.47 | 43.53 | 291.0 | 0.0 | NaN | NaN | NaN | NaN | 32.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 121.0 | 0.0 | 121.0 | 0 | 170.0 | 170.0 | 177.0 | NaN | NaN | 170.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | AM | AM | NaN | 170.0 | NaN | 0.000000 | -3.954802 | 0.000000 | 2 | 4784 | 92728800.0 | 92728800.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 0.0 |
| 3 | NaN | NaN | NaN | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | MUNICIPIO | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | AZUL | 2005-10-14 | 353.66 | NaN | NaN | False | False | False | False | True | False | False | False | False | True | SIM | False | False | False | False | False | True | NaN | NaN | 35.0 | 53.0 | 63.0 | 3aafa3a1f12f483740a52956af100223333d0e3c79bf2c... | 14.0 | NaN | NaN | NaN | 8.0 | 18.0 | 29.0 | 22.0 | 31.0 | 29.0 | > 20 | 43.854795 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 506.966667 | 5014.966667 | NaN | NaN | NaN | NaN | NaN | NaN | 189.020309 | 316.503220 | NaN | NaN | 31.333333 | NaN | NaN | NaN | NaN | 31.333333 | 8.733333 | NaN | NaN | OUTROS | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | CENTRO NORTE PIAUIENSE | VALENCA DO PIAUI | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 23.0 | 73.51 | 26.49 | 176.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 25.0 | 0.0 | 25.0 | 0 | 151.0 | 151.0 | 151.0 | NaN | NaN | 151.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | PI | PI | NaN | 151.0 | NaN | 0.000000 | 0.000000 | 0.000000 | 3 | 7429 | 24418584.0 | 24418584.0 | NaN | NaN | 87223.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | 1.0 | 2.0 | 2.0 |
| 4 | NaN | NaN | NaN | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | NaN | MUNICIPIO | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | AZUL | 2005-06-11 | NaN | NaN | NaN | False | False | False | False | True | False | False | False | False | True | NAO | False | False | False | False | False | True | NaN | NaN | NaN | 147.0 | 82.0 | c60431fbca90067f105570e1e8a684bcd7048205bbf6c4... | 24.0 | NaN | NaN | 6.0 | 10.0 | 12.0 | 45.0 | 50.0 | 48.0 | 34.0 | > 20 | 43.865753 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 556.833333 | 5014.966667 | NaN | NaN | NaN | NaN | NaN | NaN | 238.418341 | 146.443381 | NaN | NaN | 23.200000 | NaN | NaN | NaN | NaN | 34.033333 | -0.066667 | NaN | NaN | OUTROS | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | AGRESTE POTIGUAR | BAIXA VERDE | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 23.0 | 72.93 | 27.07 | 836.0 | 0.0 | NaN | NaN | NaN | NaN | 4.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 607.0 | 0.0 | 606.0 | 1 | 229.0 | 229.0 | 418.0 | NaN | NaN | 229.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | RN | RN | NaN | 229.0 | NaN | 0.000000 | -45.215311 | 0.000000 | 4 | 8001 | 38585484.0 | 38585484.0 | NaN | NaN | 23412.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | 0.0 | 0.0 |
| 5 | 634.266667 | NaN | 145.700000 | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | ASSOCIACAO PRIVADA | ALTA | SERVICOS DE EDUCACAO | ACIMA DE 1 ANO | VERDE | 2005-09-24 | 1016.48 | 10770780.0 | 30684070.0 | False | True | False | False | True | False | False | False | False | True | SIM | False | False | False | False | True | True | NaN | NaN | 11.0 | 15.0 | 144.0 | 5de08033561948a226f8ba8f8668a4ff4123be8ea7114d... | 13.0 | NaN | 2.0 | 9.0 | 29.0 | 28.0 | 26.0 | 35.0 | 18.0 | 10.0 | > 20 | 47.087671 | 634.266667 | 40.0 | 389.983333 | 389.983333 | NaN | 38.0 | 145.700000 | 36.0 | 10560780.0 | 25483750.0 | 15.0 | 309.0 | 397.633333 | 481.300000 | 4224312.0 | 10468051.0 | 5385390.0 | 15342035.0 | 10.0 | 159.0 | 99.530196 | 78.154236 | 4224312.0 | 5491605.5 | 20.433333 | 210000.0 | 5200320.0 | 5.0 | 9.0 | 20.433333 | 0.200000 | 4224312.0 | 515160.0 | ENTIDADES SEM FINS LUCRATIVOS | EDUCACAO | LESTE POTIGUAR | NATAL | EDUCACAO | 23.0 | 45.29 | 54.71 | 424.0 | 0.0 | NaN | NaN | NaN | NaN | 1.0 | 2.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 254.0 | 0.0 | 254.0 | 1 | 170.0 | 170.0 | 206.0 | 112.0 | 318.0 | 393.0 | 2.0 | 1.0 | 3.0 | 2.0 | NaN | 2.0 | NaN | 3.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 2.0 | NaN | 1.0 | SERVIÇO | RN | RN | 10770780.0 | 170.0 | 20.0 | 0.000000 | -17.475728 | 0.000000 | 5 | 8272 | 42500700.0 | 93862150.0 | 4224312.0 | 10983211.0 | 141655.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | 4.0 | 1.0 | 1.0 |
| 6 | NaN | NaN | NaN | NaN | DE R$ 100.000.000,01 A R$ 300.000.000,00 | DE R$ 100.000.000,01 A R$ 300.000.000,00 | BOA | ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU D... | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | VERDE | 2003-02-06 | 1811.66 | NaN | NaN | False | False | False | False | True | False | False | False | False | True | SIM | False | False | False | False | False | False | NaN | NaN | 53.0 | 297.0 | 268.0 | 194e619cb6417f92f75653406cf04106debc5035f13a88... | 216.0 | NaN | 5.0 | 15.0 | 43.0 | 42.0 | 29.0 | 51.0 | 78.0 | 139.0 | 15 a 20 | 15.734247 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 191.600000 | 467.233333 | NaN | NaN | NaN | NaN | NaN | NaN | 138.385891 | 126.687314 | NaN | NaN | 24.200000 | NaN | NaN | NaN | NaN | 24.200000 | 2.566667 | NaN | NaN | ADMINISTRACAO PUBLICA | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | NORTE MARANHENSE | AGLOMERACAO URBANA DE SAO LUIS | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 23.0 | 49.35 | 50.65 | 896.0 | 0.0 | NaN | NaN | NaN | NaN | 3.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 277.0 | 0.0 | 278.0 | 0 | 619.0 | 619.0 | 690.0 | NaN | NaN | 618.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | MA | MA | NaN | 618.0 | NaN | 0.000000 | -10.289855 | 0.000000 | 6 | 8626 | 195554740.0 | 195554740.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 0.0 |
| 7 | NaN | NaN | NaN | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | EMPRESARIO INDIVIDUAL | ALTA | SERVICOS DE ALOJAMENTO/ALIMENTACAO | ACIMA DE 1 ANO | VERDE | 2003-03-15 | 857.89 | NaN | NaN | False | False | False | False | True | False | False | False | False | True | SIM | False | False | False | False | False | True | NaN | NaN | 18.0 | 143.0 | 7.0 | cc734f72fdd8753ba2e7638f3d09e0597fd859735904da... | 3.0 | NaN | 10.0 | 26.0 | 34.0 | 38.0 | 28.0 | 18.0 | 7.0 | 4.0 | > 20 | 26.520548 | NaN | 63.0 | NaN | NaN | NaN | 63.0 | NaN | 63.0 | NaN | NaN | NaN | NaN | 274.300000 | 274.300000 | NaN | NaN | NaN | NaN | NaN | NaN | 44.566270 | 29.254984 | NaN | NaN | 2.433333 | NaN | NaN | NaN | NaN | 2.433333 | -0.600000 | NaN | NaN | OUTROS | ALIMENTACAO | CENTRO AMAZONENSE | MANAUS | ALOJAMENTO E ALIMENTACAO | 23.0 | 22.62 | 77.38 | 428.0 | 10.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 260.0 | 2.0 | 260.0 | 1 | 168.0 | 160.0 | 186.0 | NaN | NaN | 168.0 | NaN | NaN | 1.0 | NaN | NaN | 1.0 | NaN | 1.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | SERVIÇO | AM | AM | NaN | 168.0 | NaN | 5.000000 | -9.677419 | 1.219512 | 7 | 8986 | 26994384.0 | 27924384.0 | NaN | NaN | 382387.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 3.0 | 3.0 | 5.0 | 5.0 |
| 8 | 61.333333 | NaN | 17.933333 | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS | ACIMA DE 1 ANO | VERDE | 2010-05-20 | NaN | 19171824.0 | 19381824.0 | False | True | False | False | True | False | False | False | False | True | NAO | False | False | False | False | True | True | 2.0 | NaN | 17.0 | 98.0 | 64.0 | 7e46107cb32e64f7f90ec16372d29f205f0d9781140308... | 6.0 | 5.0 | 10.0 | 36.0 | 40.0 | 43.0 | 19.0 | 11.0 | 7.0 | 4.0 | 5 a 10 | 8.446575 | 61.333333 | 41.0 | 32.544444 | 32.544444 | NaN | 40.0 | 17.933333 | 39.0 | 18751824.0 | 18961824.0 | 1.0 | 118.0 | 83.733333 | 83.733333 | 7500729.5 | 7500729.5 | 6390608.0 | 6460608.0 | 1.0 | 118.0 | 30.029853 | 18.908407 | 7500729.5 | 7500729.5 | 2.033333 | 210000.0 | 210000.0 | 1.0 | 118.0 | 2.033333 | -0.600000 | 7500729.5 | 7500729.5 | ENTIDADES EMPRESARIAIS | SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ... | VALE DO ACRE | RIO BRANCO | ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS | 23.0 | 28.18 | 71.82 | 452.0 | 58.0 | NaN | NaN | NaN | NaN | 6.0 | 3.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 270.0 | 49.0 | 270.0 | 0 | 182.0 | 179.0 | 131.0 | 118.0 | 118.0 | 181.0 | 1.0 | 1.0 | 2.0 | 5.0 | NaN | 2.0 | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 2.0 | NaN | 1.0 | SERVIÇO | AC | AC | 19171824.0 | 181.0 | 3.0 | 1.675978 | 38.931298 | 27.605634 | 8 | 10968 | 35185428.0 | 35185428.0 | 7500729.5 | 7500729.5 | 559626.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 11.0 | 11.0 | 1.0 | 1.0 |
| 9 | 116.133333 | NaN | 116.133333 | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | SERVICOS ADMINISTRATIVOS | ACIMA DE 1 ANO | VERDE | 2007-10-18 | 2346.09 | 23182200.0 | 23182200.0 | False | True | False | False | True | False | False | False | False | True | NAO | False | False | False | False | True | True | NaN | NaN | 15.0 | 117.0 | 16.0 | 2206453fbc92af65e47ce6ee2be27fa90ac427845ea0a5... | 1.0 | NaN | 23.0 | 41.0 | 21.0 | 26.0 | 16.0 | 11.0 | 7.0 | 2.0 | 10 a 15 | 11.035616 | 116.133333 | 64.0 | 116.133333 | 116.133333 | NaN | 49.0 | 116.133333 | 34.0 | 23182200.0 | 23182200.0 | NaN | 161.0 | 113.533333 | 113.533333 | 9272880.0 | 9272880.0 | 23182200.0 | 23182200.0 | NaN | 161.0 | 40.449775 | 21.582770 | 9272880.0 | 9272880.0 | 2.933333 | 23182200.0 | 23182200.0 | NaN | 161.0 | 2.933333 | -0.500000 | 9272880.0 | 9272880.0 | ENTIDADES EMPRESARIAIS | SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGIST... | NaN | NaN | ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME... | 23.0 | 61.49 | 38.51 | 978.0 | 29.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 830.0 | 50.0 | 830.0 | 0 | 148.0 | 167.0 | 220.0 | 161.0 | 161.0 | 148.0 | 1.0 | 1.0 | 2.0 | 1.0 | 1.0 | 1.0 | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 2.0 | NaN | 1.0 | SERVIÇO | RO | RO | 23182200.0 | 148.0 | NaN | -11.377246 | -32.727273 | 31.545741 | 9 | 12743 | 22357944.0 | 22357944.0 | 9272880.0 | 9272880.0 | 248083.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 3.0 | 3.0 | 0.0 | 0.0 |
Last rows
| coligada_mais_antiga_ativa | coligada_mais_antiga_baixada | coligada_mais_nova_ativa | coligada_mais_nova_baixada | de_faixa_faturamento_estimado | de_faixa_faturamento_estimado_grupo | de_indicador_telefone | de_natureza_juridica | de_nivel_atividade | de_ramo | de_saude_rescencia | de_saude_tributaria | dt_situacao | empsetorcensitariofaixarendapopulacao | faturamento_est_coligados | faturamento_est_coligados_gp | fl_antt | fl_email | fl_epp | fl_ltda | fl_matriz | fl_me | fl_mei | fl_optante_simei | fl_optante_simples | fl_passivel_iss | fl_rm | fl_sa | fl_simples_irregular | fl_spa | fl_st_especial | fl_telefone | fl_veiculo | grau_instrucao_macro_analfabeto | grau_instrucao_macro_desconhecido | grau_instrucao_macro_escolaridade_fundamental | grau_instrucao_macro_escolaridade_media | grau_instrucao_macro_escolaridade_superior | id | idade_acima_de_58 | idade_ate_18 | idade_de_19_a_23 | idade_de_24_a_28 | idade_de_29_a_33 | idade_de_34_a_38 | idade_de_39_a_43 | idade_de_44_a_48 | idade_de_49_a_53 | idade_de_54_a_58 | idade_emp_cat | idade_empresa_anos | idade_maxima_coligadas | idade_maxima_socios | idade_media_coligadas | idade_media_coligadas_ativas | idade_media_coligadas_baixadas | idade_media_socios | idade_minima_coligadas | idade_minima_socios | max_faturamento_est_coligados | max_faturamento_est_coligados_gp | max_filiais_coligados | max_funcionarios_coligados_gp | max_meses_servicos | max_meses_servicos_all | max_vl_folha_coligados | max_vl_folha_coligados_gp | media_faturamento_est_coligados | media_faturamento_est_coligados_gp | media_filiais_coligados | media_funcionarios_coligados_gp | media_meses_servicos | media_meses_servicos_all | media_vl_folha_coligados | media_vl_folha_coligados_gp | meses_ultima_contratacaco | min_faturamento_est_coligados | min_faturamento_est_coligados_gp | min_filiais_coligados | min_funcionarios_coligados_gp | min_meses_servicos | min_meses_servicos_all | min_vl_folha_coligados | min_vl_folha_coligados_gp | natureza_juridica_macro | nm_divisao | nm_meso_regiao | nm_micro_regiao | nm_segmento | nu_meses_rescencia | percent_func_genero_fem | percent_func_genero_masc | qt_admitidos | qt_admitidos_12meses | qt_alteracao_socio_180d | qt_alteracao_socio_365d | qt_alteracao_socio_90d | qt_alteracao_socio_total | qt_art | qt_coligadas | qt_coligados | qt_coligados_agropecuaria | qt_coligados_atividade_alto | qt_coligados_atividade_baixo | qt_coligados_atividade_inativo | qt_coligados_atividade_medio | qt_coligados_atividade_mt_baixo | qt_coligados_ativo | qt_coligados_baixada | qt_coligados_ccivil | qt_coligados_centro | qt_coligados_comercio | qt_coligados_epp | qt_coligados_exterior | qt_coligados_inapta | qt_coligados_industria | qt_coligados_ltda | qt_coligados_matriz | qt_coligados_me | qt_coligados_mei | qt_coligados_nordeste | qt_coligados_norte | qt_coligados_nula | qt_coligados_sa | qt_coligados_serviço | qt_coligados_sudeste | qt_coligados_sul | qt_coligados_suspensa | qt_desligados | qt_desligados_12meses | qt_ex_funcionarios | qt_filiais | qt_funcionarios | qt_funcionarios_12meses | qt_funcionarios_24meses | qt_funcionarios_coligados | qt_funcionarios_coligados_gp | qt_funcionarios_grupo | qt_ramos_coligados | qt_regioes_coligados | qt_socios | qt_socios_coligados | qt_socios_feminino | qt_socios_masculino | qt_socios_pep | qt_socios_pf | qt_socios_pj | qt_socios_pj_ativos | qt_socios_pj_baixados | qt_socios_pj_inaptos | qt_socios_pj_nulos | qt_socios_pj_suspensos | qt_socios_st_regular | qt_socios_st_suspensa | qt_ufs_coligados | setor | sg_uf | sg_uf_matriz | sum_faturamento_estimado_coligadas | total | total_filiais_coligados | tx_crescimento_12meses | tx_crescimento_24meses | tx_rotatividade | Unnamed_0_x | Unnamed_0_y | vl_faturamento_estimado_aux | vl_faturamento_estimado_grupo_aux | vl_folha_coligados | vl_folha_coligados_gp | vl_frota | vl_idade_maxima_socios_pj | vl_idade_media_socios_pj | vl_idade_minima_socios_pj | vl_potenc_cons_oleo_gas | vl_total_tancagem | vl_total_tancagem_grupo | vl_total_veiculos_antt | vl_total_veiculos_antt_grupo | vl_total_veiculos_leves | vl_total_veiculos_leves_grupo | vl_total_veiculos_pesados | vl_total_veiculos_pesados_grupo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 255 | NaN | NaN | NaN | NaN | DE R$ 100.000.000,01 A R$ 300.000.000,00 | DE R$ 100.000.000,01 A R$ 300.000.000,00 | NaN | ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU D... | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | VERDE | 2005-11-03 | 3419.68 | NaN | NaN | False | True | False | False | True | False | False | False | False | True | SIM | False | False | False | False | True | True | NaN | NaN | 63.0 | 271.0 | 229.0 | 1ec76d8ef1d7c6bb73ef86a43d713725b1b610240bdf4a... | 210.0 | 1.0 | 8.0 | 11.0 | 40.0 | 28.0 | 30.0 | 48.0 | 71.0 | 116.0 | 15 a 20 | 19.843836 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 490.433333 | 490.433333 | NaN | NaN | NaN | NaN | NaN | NaN | 180.181442 | 97.031514 | NaN | NaN | 3.466667 | NaN | NaN | NaN | NaN | 3.466667 | 1.800000 | NaN | NaN | ADMINISTRACAO PUBLICA | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | NORTE MARANHENSE | AGLOMERACAO URBANA DE SAO LUIS | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 22.0 | 55.42 | 44.58 | 1484.0 | 6.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 920.0 | 8.0 | 920.0 | 0 | 564.0 | 566.0 | 615.0 | NaN | NaN | 563.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | MA | MA | NaN | 563.0 | NaN | -0.353357 | -8.292683 | 1.415929 | 255 | 452076 | 169642190.0 | 169642190.0 | NaN | NaN | 10151299.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 101.0 | 101.0 | 0.0 | 0.0 |
| 256 | 516.933333 | NaN | 39.733333 | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | SERVICOS DE SAUDE | ACIMA DE 1 ANO | VERDE | 2005-11-03 | 2348.34 | 3.915216e+06 | 3.915216e+06 | False | True | False | False | True | False | False | False | False | True | SIM | False | False | False | False | True | True | NaN | NaN | 12.0 | 91.0 | 42.0 | a3d4217a7c01f6cabd26d86cb283923c682a18d516f015... | NaN | NaN | 13.0 | 23.0 | 32.0 | 33.0 | 18.0 | 16.0 | 6.0 | 4.0 | 15 a 20 | 19.761644 | 516.933333 | 44.0 | 203.111111 | 203.111111 | NaN | 41.5 | 39.733333 | 39.0 | 2.843683e+06 | 2.843683e+06 | NaN | 13.0 | 121.600000 | 121.600000 | 947894.4 | 947894.4 | 1.305072e+06 | 1.305072e+06 | NaN | 7.000000 | 52.999543 | 40.757037 | 4.533408e+05 | 4.533408e+05 | 3.933333 | 329702.4 | 329702.4 | NaN | 4.0 | 3.933333 | 0.466667 | 164851.2 | 164851.2 | ENTIDADES EMPRESARIAIS | ATIVIDADES DE ATENCAO A SAUDE HUMANA | CENTRO NORTE PIAUIENSE | TERESINA | SAUDE HUMANA E SERVICOS SOCIAIS | 23.0 | 69.66 | 30.34 | 270.0 | 14.0 | NaN | NaN | NaN | NaN | NaN | 3.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 124.0 | 9.0 | 124.0 | 3 | 146.0 | 141.0 | 166.0 | 21.0 | 21.0 | 145.0 | 3.0 | 1.0 | 2.0 | 4.0 | 1.0 | 1.0 | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 2.0 | NaN | 1.0 | SERVIÇO | PI | PI | 3.915216e+06 | 145.0 | NaN | 3.546099 | -12.048193 | 6.271777 | 256 | 452130 | 24727680.0 | 28697680.0 | 1.360022e+06 | 1.360022e+06 | 182413.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4.0 | 4.0 | 2.0 | 2.0 |
| 257 | 25.566667 | NaN | 25.566667 | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITAD... | ALTA | SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS | ACIMA DE 1 ANO | VERDE | 2005-10-14 | 3021.53 | 2.100000e+05 | 2.100000e+05 | False | False | False | False | True | False | False | False | False | True | SIM | False | False | False | False | False | True | 1.0 | NaN | 73.0 | 122.0 | 5.0 | feb9c97a3f694c22a919d9544c433da92d34d5717b43d5... | 2.0 | NaN | 19.0 | 28.0 | 46.0 | 35.0 | 27.0 | 19.0 | 16.0 | 9.0 | 15 a 20 | 16.769863 | 25.566667 | NaN | 25.566667 | 25.566667 | NaN | NaN | 25.566667 | NaN | 2.100000e+05 | 2.100000e+05 | NaN | NaN | 92.233333 | 92.233333 | NaN | NaN | 2.100000e+05 | 2.100000e+05 | NaN | NaN | 18.929612 | 8.896976 | NaN | NaN | 3.700000 | 210000.0 | 210000.0 | NaN | NaN | 3.700000 | -0.533333 | NaN | NaN | OUTROS | SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ... | NORTE MARANHENSE | AGLOMERACAO URBANA DE SAO LUIS | ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS | 23.0 | 4.98 | 95.02 | 983.0 | 230.0 | NaN | NaN | NaN | NaN | 5.0 | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 1.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 777.0 | 186.0 | 774.0 | 0 | 206.0 | 152.0 | 119.0 | NaN | NaN | 201.0 | 1.0 | 1.0 | 1.0 | 1.0 | NaN | NaN | NaN | 1.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | SERVIÇO | MA | MA | 2.100000e+05 | 201.0 | NaN | 35.526316 | 73.109244 | 101.086957 | 257 | 452676 | 31321728.0 | 31321728.0 | NaN | NaN | 85833.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4.0 | 4.0 | 0.0 | 0.0 |
| 258 | NaN | NaN | NaN | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | ORGAO PUBLICO DO PODER EXECUTIVO MUNICIPAL | MEDIA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | AZUL | 2000-12-27 | 1359.01 | NaN | NaN | False | False | False | False | True | False | False | False | False | True | SIM | False | False | False | False | False | False | NaN | NaN | 18.0 | 305.0 | 55.0 | efd51c8f53a5931f1778398c485a861169c99a40072d8f... | 206.0 | NaN | 2.0 | 2.0 | 10.0 | 13.0 | 11.0 | 9.0 | 51.0 | 74.0 | 15 a 20 | 17.846575 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 607.633333 | 607.633333 | NaN | NaN | NaN | NaN | NaN | NaN | 353.954938 | 281.495431 | NaN | NaN | 37.266667 | NaN | NaN | NaN | NaN | 37.266667 | -0.266667 | NaN | NaN | ADMINISTRACAO PUBLICA | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | CENTRO NORTE PIAUIENSE | TERESINA | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 23.0 | 14.02 | 85.98 | 572.0 | 0.0 | NaN | NaN | NaN | NaN | 6.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 194.0 | 0.0 | 194.0 | 0 | 378.0 | 378.0 | 379.0 | NaN | NaN | 378.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | PI | PI | NaN | 378.0 | NaN | 0.000000 | -0.263852 | 0.000000 | 258 | 453793 | 59810076.0 | 59810076.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 0.0 |
| 259 | NaN | NaN | NaN | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | NaN | MUNICIPIO | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | AZUL | 2005-04-02 | 372.23 | NaN | NaN | False | False | False | False | True | False | False | False | False | True | NAO | False | False | False | False | False | True | NaN | NaN | 15.0 | 305.0 | 33.0 | 120ecac76e64ace3880969e7a6c7a20ff116b94a411fd0... | 23.0 | NaN | 2.0 | 5.0 | 35.0 | 44.0 | 92.0 | 60.0 | 61.0 | 31.0 | > 20 | 43.539726 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 501.066667 | 5014.966667 | NaN | NaN | NaN | NaN | NaN | NaN | 181.592823 | 92.680587 | NaN | NaN | 2.500000 | NaN | NaN | NaN | NaN | 2.500000 | -5.100000 | NaN | NaN | OUTROS | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | LESTE POTIGUAR | LITORAL NORDESTE | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 23.0 | 52.12 | 47.88 | 977.0 | 9.0 | NaN | NaN | NaN | NaN | 18.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 624.0 | 0.0 | 624.0 | 1 | 353.0 | 344.0 | 564.0 | NaN | NaN | 353.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | RN | RN | NaN | 353.0 | NaN | 2.616279 | -37.411348 | 0.000000 | 259 | 454341 | 63313164.0 | 63313164.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | 1.0 | 1.0 |
| 260 | 206.900000 | NaN | 27.166667 | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | COOPERATIVA | ALTA | SERVICOS FINANCEIROS | ACIMA DE 1 ANO | VERDE | 2005-11-03 | 1365.70 | 1.462024e+07 | 1.779363e+07 | False | True | False | False | True | False | False | False | False | True | NAO | False | False | False | False | True | False | NaN | NaN | NaN | 16.0 | 72.0 | b6966d868fb7976f993aca02fb667c9ae8f5ebf4d2e033... | 5.0 | 2.0 | 6.0 | 24.0 | 18.0 | 21.0 | 2.0 | 6.0 | 2.0 | 2.0 | 15 a 20 | 18.980822 | 206.900000 | 52.0 | 126.222222 | 126.222222 | NaN | 52.0 | 27.166667 | 52.0 | 1.045775e+07 | 1.045775e+07 | 3.0 | 57.0 | 176.300000 | 218.200000 | 4183099.2 | 4183099.2 | 4.873414e+06 | 5.931209e+06 | 3.0 | 42.333333 | 51.353933 | 43.703509 | 2.088115e+06 | 2.617013e+06 | 2.266667 | 700617.6 | 3461875.2 | 3.0 | 26.0 | 2.266667 | -0.300000 | 350308.8 | 1730937.6 | ENTIDADES EMPRESARIAIS | ATIVIDADES DE SERVICOS FINANCEIROS | NaN | NaN | ATIVIDADES FINANCEIRAS DE SEGUROS E SERVICOS R... | 23.0 | 55.68 | 44.32 | 152.0 | 12.0 | NaN | NaN | NaN | NaN | NaN | 3.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 3.0 | 2.0 | 0.0 | 0.0 | 63.0 | 9.0 | 63.0 | 0 | 89.0 | 86.0 | 73.0 | 106.0 | 127.0 | 88.0 | 3.0 | 2.0 | 2.0 | 3.0 | NaN | 1.0 | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | 2.0 | SERVIÇO | RO | RO | 1.462024e+07 | 88.0 | 3.0 | 3.488372 | 21.917808 | 10.285714 | 260 | 454844 | 23903424.0 | 23903424.0 | 6.264346e+06 | 7.851038e+06 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 0.0 |
| 261 | 158.600000 | NaN | 20.600000 | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | SERVICOS DE SAUDE | ACIMA DE 1 ANO | VERDE | 2002-11-16 | 2484.07 | 4.200000e+05 | 4.200000e+05 | False | False | False | False | True | False | False | False | False | True | SIM | False | False | False | False | False | True | 1.0 | NaN | 4.0 | 119.0 | 73.0 | 4a87a82771996c18afc68a17d139bd318d08fa3e5dcf9f... | NaN | 6.0 | 20.0 | 46.0 | 44.0 | 34.0 | 23.0 | 12.0 | 8.0 | 4.0 | > 20 | 22.493151 | 158.600000 | 51.0 | 89.600000 | 89.600000 | NaN | 36.0 | 20.600000 | 27.0 | 2.100000e+05 | 2.100000e+05 | NaN | NaN | 271.800000 | 271.800000 | NaN | NaN | 2.100000e+05 | 2.100000e+05 | NaN | NaN | 63.100493 | 49.762882 | NaN | NaN | 2.533333 | 210000.0 | 210000.0 | NaN | NaN | 2.533333 | 0.600000 | NaN | NaN | ENTIDADES EMPRESARIAIS | ATIVIDADES DE ATENCAO A SAUDE HUMANA | CENTRO NORTE PIAUIENSE | TERESINA | SAUDE HUMANA E SERVICOS SOCIAIS | 25.0 | 68.02 | 31.98 | 414.0 | 27.0 | NaN | NaN | NaN | NaN | 4.0 | 2.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 211.0 | 30.0 | 210.0 | 3 | 203.0 | 206.0 | 243.0 | NaN | NaN | 224.0 | 2.0 | 1.0 | 4.0 | 5.0 | 1.0 | 2.0 | NaN | 4.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 3.0 | NaN | 1.0 | SERVIÇO | PI | PI | 4.200000e+05 | 197.0 | NaN | -1.456311 | -16.460905 | 14.669927 | 261 | 457457 | 30136860.0 | 33145394.0 | NaN | NaN | 447145.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 7.0 | 7.0 | 0.0 | 0.0 |
| 262 | 56.200000 | NaN | 56.200000 | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS | ACIMA DE 1 ANO | VERDE | 2006-02-01 | NaN | 9.300000e+05 | 9.300000e+05 | False | True | False | False | True | False | False | False | False | True | SIM | False | False | False | False | True | False | NaN | NaN | 150.0 | 127.0 | 2.0 | f3b468c4066fac0d2de28bdafa87ec8b9d103a085cf7de... | 34.0 | NaN | 6.0 | 21.0 | 26.0 | 45.0 | 41.0 | 43.0 | 44.0 | 19.0 | 10 a 15 | 12.745205 | 56.200000 | 49.0 | 56.200000 | 56.200000 | NaN | 41.0 | 56.200000 | 33.0 | 9.300000e+05 | 9.300000e+05 | NaN | NaN | 5099.066667 | 5099.066667 | NaN | NaN | 9.300000e+05 | 9.300000e+05 | NaN | NaN | 173.809677 | 61.097177 | NaN | NaN | 20.733333 | 930000.0 | 930000.0 | NaN | NaN | 24.700000 | -0.566667 | NaN | NaN | ENTIDADES EMPRESARIAIS | SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ... | CENTRO AMAZONENSE | MANAUS | ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS | 23.0 | 63.44 | 36.56 | 981.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 702.0 | 8.0 | 702.0 | 0 | 279.0 | 287.0 | 296.0 | NaN | NaN | 279.0 | 1.0 | 1.0 | 2.0 | 1.0 | NaN | 2.0 | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 2.0 | NaN | 1.0 | SERVIÇO | AM | AM | 9.300000e+05 | 279.0 | NaN | -2.787456 | -5.743243 | 2.826855 | 262 | 457917 | 40955220.0 | 40955220.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 0.0 |
| 263 | 321.633333 | NaN | 10.366667 | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | COOPERATIVA | ALTA | SEGUROS, PLANOS DE PREVIDENCIA E PLANOS DE SAUDE | ACIMA DE 1 ANO | AZUL | 2003-11-08 | 2281.44 | 2.275368e+07 | 2.720860e+07 | False | True | False | False | True | False | False | False | False | True | NAO | False | False | False | False | True | True | NaN | NaN | 6.0 | 45.0 | 69.0 | 98448fefe3e358578fa643b63fcdcf4a3f2dcb496863f8... | 3.0 | 7.0 | 9.0 | 22.0 | 22.0 | 21.0 | 12.0 | 12.0 | 6.0 | 6.0 | > 20 | 26.402740 | 321.633333 | 70.0 | 166.300000 | 166.300000 | NaN | 59.5 | 10.366667 | 45.0 | 2.107004e+07 | 2.552496e+07 | 4.0 | 72.0 | 286.333333 | 286.333333 | 8428018.0 | 10550477.0 | 3.792280e+06 | 4.534767e+06 | 3.5 | 36.500000 | 67.994215 | 55.208629 | 4.244919e+06 | 5.306148e+06 | 2.933333 | 123638.4 | 123638.4 | 3.0 | 1.0 | 2.933333 | 0.333333 | 61819.2 | 61819.2 | ENTIDADES EMPRESARIAIS | SEGUROS RESSEGUROS PREVIDENCIA COMPLEMENTAR E ... | VALE DO ACRE | RIO BRANCO | ATIVIDADES FINANCEIRAS DE SEGUROS E SERVICOS R... | 23.0 | 70.83 | 29.17 | 282.0 | 18.0 | NaN | NaN | NaN | NaN | 1.0 | 6.0 | 6.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 6.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 6.0 | 0.0 | 0.0 | 0.0 | 5.0 | 0.0 | 0.0 | 5.0 | 1.0 | 0.0 | 0.0 | 161.0 | 11.0 | 160.0 | 5 | 121.0 | 114.0 | 109.0 | 59.0 | 73.0 | 319.0 | 4.0 | 2.0 | 4.0 | 6.0 | 1.0 | 3.0 | NaN | 4.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 4.0 | NaN | 3.0 | SERVIÇO | AC | AC | 2.275368e+07 | 120.0 | 7.0 | 6.140351 | 11.009174 | 9.361702 | 263 | 459287 | 30033828.0 | 61489496.0 | 8.489837e+06 | 1.061230e+07 | 156585.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | 2.0 | 1.0 | 1.0 |
| 264 | 596.233333 | NaN | 16.700000 | NaN | DE R$ 300.000.000,01 A R$ 500.000.000,00 | DE R$ 500.000.000,01 A 1 BILHAO DE REAIS | BOA | SOCIEDADE ANONIMA FECHADA | ALTA | INDUSTRIA DIGITAL | ACIMA DE 1 ANO | VERDE | 2008-01-14 | 5985.49 | 5.223031e+09 | 5.451955e+09 | False | True | False | False | True | False | False | False | False | True | SIM | True | False | False | False | True | False | NaN | NaN | 140.0 | 2447.0 | 563.0 | 251f454db948590c50df496ea83f76e2227e24a32c2814... | 5.0 | 7.0 | 643.0 | 949.0 | 749.0 | 444.0 | 200.0 | 95.0 | 41.0 | 17.0 | 10 a 15 | 10.794521 | 596.233333 | 72.0 | 106.631111 | 106.631111 | NaN | 52.5 | 16.700000 | 35.0 | 5.150974e+09 | 5.372531e+09 | 275.0 | 1716.0 | 30.333333 | 146.600000 | 171568880.0 | 241816100.0 | 3.482021e+08 | 3.634637e+08 | 24.0 | 361.600000 | 23.341541 | 18.284345 | 3.669588e+07 | 5.131406e+07 | 3.433333 | 210000.0 | 210000.0 | 1.0 | 10.0 | 3.433333 | -0.466667 | 288489.6 | 288489.6 | ENTIDADES EMPRESARIAIS | ATIVIDADES DE PRESTACAO DE SERVICOS DE INFORMACAO | NORTE MARANHENSE | AGLOMERACAO URBANA DE SAO LUIS | INFORMACAO E COMUNICACAO | 23.0 | 33.56 | 66.44 | 5340.0 | 465.0 | NaN | NaN | NaN | NaN | NaN | 15.0 | 15.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 15.0 | 0.0 | 0.0 | 8.0 | 1.0 | 0.0 | 0.0 | 0.0 | 10.0 | 0.0 | 15.0 | 0.0 | 0.0 | 4.0 | 1.0 | 0.0 | 10.0 | 3.0 | 2.0 | 0.0 | 0.0 | 2168.0 | 394.0 | 2162.0 | 6 | 3172.0 | 3186.0 | 3460.0 | 1229.0 | 1808.0 | 3787.0 | 7.0 | 4.0 | 5.0 | 28.0 | NaN | 4.0 | NaN | 5.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 4.0 | NaN | 5.0 | SERVIÇO | MA | MA | 5.223031e+09 | 3150.0 | 288.0 | -0.439422 | -8.323699 | 12.561773 | 264 | 460027 | 459934850.0 | 560530400.0 | 1.834794e+08 | 2.565703e+08 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 0.0 |